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 “santerias” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
santerias931184(None) 
santeras8311061santer_as
santeria8311651santeria_
asterias8317012_asterias
bacterias1349282bacterias
hatterias1258742hatterias
sangrias938372san_grias
sanserifs1244662sanserifs
santera7311302santer_a_
santeros8311192santer_os
anaemias1069203_anaemias
anemias92512143_an_emias
anergias947173_an_ergias
angarias9310553_angarias
antennas846403_antennas
anterior8611053_anterior
antherids1368723_antherids
antibias10312083_antibias
anurias7312253_an_urias
apteria9312913_apteria_
arterial8313633_arterial
arterials949693_arterials
arteries8321483_arteries
asteria7316183_asteria_
bacteria1248993bacteria_
bacterial1348363bacterial
bacterials1446333bacterials
bacterins13410643bacterins
banterers112410003banterers
bantering122414233bantering
banters94623113banter__s
batteries11615113batteries
cafeterias1553773cafeterias
canneries11313083canneries
cantering122417373cantering
canters94827733canter__s
cantorial1149813cantorial
cantrips12318933cant_rips
catteries11815523catteries
cauteries11615393cauteries
eateries8324313ea_teries
enterics10312853_enterics
fantasias1286993fantasias
franserias1344253franserias
gallerias1047133gallerias
gantries91413793gant_ries
hatteria1137863hatteria_
hysterias1547153hysterias
interims101013073_interims
lanterns838303lanter_ns
latrias71913213la_t_rias
listerias959233listerias
mantras93815863mant_r_as
masteries111018493masteries
material10314103ma_terial
materials11510803ma_terials
pantries101817393pant_ries
psalteria1144003psalteria_
psalteries1276563psalteries
rancherias1544093rancherias
ranters73323643ranter__s
salterns8388903salter_ns
salters73622253salter__s
sanatoria947173sanatoria_
sanders84025943sander__s
sangers84421943sanger__s
sangria838113san_gria_
sanitaria947063sanitaria_
sanitarian1047443sanitarian
sanitarians1146243sanitarians
sanitaries1049913sanitaries
sanitoria946673sanitoria_
sanseis73011603sanse_i_s
sanserif1146133sanseri_f
santero7311133santer__o
santims9312603sant__ims
santirs7312963sant__irs
santolinas1043753santolinas
santonicas1244203santonicas
santonins948453santonins
santurs7310763santur__s
sapremias1344953sapremias
sartorial948383sartorial
sartorius947163sartorius
sataras7315063sa_tar_as
satoris7317253sa_tori_s
satyrids1245623sa_tyrids
saunterers1044383saunterers
sauntering1137223sauntering
saunters82911753saunter__s
sauternes947023sauternes
sentries81318053sent_ries
sintering101014803sintering
sinters74024083sinter__s
swanneries1344363swanneries
synergias1343423syn_ergias
tanneries9310423tanneries
tantaras8269543tantar_as
tantras73112093tant_r_as
taquerias1843533taquerias
wanters104420093wanter__s
wasteries121115343wasteries
wisterias1248103wisterias
yantras10259003yant_r_as

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.406440125.6
2DLD Change Limit1486411047.43619989.4
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.88822653.5
 
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.