Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “aroynting” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
aroynting134463(None) 
arointing1049361arointing
amounting1236642amounting
anointing1038622anointing
fronting12310442fro_nting
aborning1188003aborn_ing
aborting11710253abo_rting
abounding1335193abounding
abrogating1497983abrogating
absenting1236993absenting
accenting1487823accenting
accounting1544923accounting
adopting1237453ado_pting
adorning1087323adorn_ing
affronting1742603affro_nting
agenting1039383a_genting
anting75827023a___nting
appointing1545323appointing
aproning11311793apro_n_ing
argentine1047893argentine
arousing93811803aro_using
aroynt9312893aroynt___
aroynted1244523aroynt_ed
aroynts1036633aroynt__s
arranging1156303arranging
arresting1038633arresting
arrogating121778393arrogating
assenting1038163assenting
atoning83514873ato_n_ing
bromating1439173bromating
bronzing2037693bro_nzing
browning14299643brown_ing
counting113115273_counting
crooning113112113croon_ing
crowning143510033crown_ing
droning93013723dro_n_ing
drownding1564123drownding
drowning13298363drown_ing
frosting12311183fro_sting
frouncing1534763frouncing
frowning15307833frown_ing
frowsting1634683frowsting
garmenting1445483garmenting
garoting10510703garo__ting
garotting1136103garo_tting
granting103514523gr_anting
groaning102410283groan_ing
groining102310633groin_ing
grounding1236083grounding
grouting103410793gro_uting
grunting10269583gr_unting
ironing82414013iro_n_ing
jointing16248613_jointing
margenting1446153margenting
marooning1238593maroon_ing
mounting112711813_mounting
orienting1038723orienting
parenting12611583par_enting
pointing112813683_pointing
printing113216083pr_inting
probating14311193probating
profiting1549983profiting
promoting1439923promoting
prompting1637203prompting
pronating12313763pronating
pronging123511843pro_nging
prorating12314283prorating
ranting84025413_r_anting
renting84026853_r_enting
roasting93012703_roasting
roosting93411463_roosting
rooting83522433_ro_oting
rotating92614553_rotating
rotting82919683_ro_tting
rounding102812283_rounding
rousting93913273_rousting
routing83821093_ro_uting
trotting92510913tro_tting
trouncing1235153trouncing
truanting1035603truanting
trysting12267053tr_ysting
warranting1444743warranting
wonting113214103_wo_nting
wronging13327393wro_nging

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.453394461.4
2DLD Change Limit148641846.75022020.9
3Display Results84840.0302800.0
 (SQL Overall)178691847.23324705.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.