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 “aroynted” 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.

96 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
aroynted124452(None) 
arointed939001arointed
amounted1135532amounted
anointed938342anointed
aroynt9312892aroynt__
aroynts1036632aroynt_s
fronted114011272fro_nted
aborted10310423abo_rted
abounded1234903abounded
abrogated13126713abrogated
absented1156613absented
accented13107773accented
accounted1444823accounted
acorned10238273acorn_ed
adopted1136253ado_pted
adorned9256893adorn_ed
affronted1642503affro_nted
agented939423a_gented
anointer837823anointer
anted66328243a___nted
appointed1444803appointed
aproned10311503apro_n_ed
arcuated1138803arcuated
areolated1089713areolated
aroint6328153aroint__
aroints7313133aroint_s
around72712413aroun__d
aroused84914343aro_used
aroynting1344633aroynting
arranged1036933arranged
arrested939153arrested
arrogated11147143arrogated
assented957513assented
atoned75417543ato_n_ed
azoted16388593azo__ted
bromated1339173bromated
bronzed19308213bro_nzed
browned134710973brown_ed
counted103815803_counted
crooned103813343croon_ed
crowned133912433crown_ed
droned84616863dro_n_ed
drownded14334433drownded
drowned12419903drown_ed
fronded12388863fro_nded
fronter103611583fro_nter
frontes104214163fro_ntes
frosted113211873fro_sted
frounced1434493frounced
frowned14348833frown_ed
frowsted1534313frowsted
garmented1345883garmented
garoted9710133garo__ted
garotted1066193garo_tted
granted94715103gr_anted
groaned9259973groan_ed
groined92710813groin_ed
grounded1136573grounded
grouted94111503gro_uted
groyne1037213groyn_e_
groynes1137823groyn_es
grunted9339283gr_unted
ironed74916013iro_n_ed
jointed15378503_jointed
margented1346813margented
marooned1138563maroon_ed
mounted103611533_mounted
oriented937483oriented
parented11912213par_ented
pointed103813983_pointed
printed104016373pr_inted
probated13410863probated
profited14279973profited
promoted13310543promoted
prompted1536903prompted
pronated11414053pronated
pronged113912393pro_nged
prorated11513713prorated
ranted74324703_r_anted
rented74426593_r_ented
roasted83912663_roasted
roosted83211883_roosted
rooted75424003_ro_oted
rotated82715293_rotated
rotted74524433_ro_tted
rounded93013503_rounded
rousted84013323_rousted
routed75624333_ro_uted
royster103110533_royster
trotted83711283tro_tted
trounced1135033trounced
truanted935373truanted
trysted11428273tr_ysted
warranted1345013warranted
wonted103213283_wo_nted
wronged12397673wro_nged

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 Filter1786911461620.423422437.4
2DLD Change Limit146162967.39019778.3
3Display Results96960.0462087.0
 (SQL Overall)178691967.85922737.1
 
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.