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

82 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
seatrains94760(None) 
seatrain847921seatrain_
detrains9411762de_trains
entrains8312962_entrains
quatrains1845582quatrains
reattains946442reattains
restrains9311622restrains
retrains8314532re_trains
sextains15246812sext_ains
strains74218152s__trains
attains7310983__attains
destains9311813dest_ains
detains83716093de_t_ains
detrain8412253de_train_
dextrans1695983dextra_ns
dextrins16117823dextr_ins
distrains10411333distrains
engrains937583_engrains
entrails8310163_entrails
entrain7313073_entrain_
estrins7315853_estr_ins
eyestrains1343563eyestrains
mistrains11511353mistrains
oestrins8312673oestr_ins
overtrains13109503overtrains
pearmains1345263pearmains
pertains102113423pert_ains
pretrains11410143pretrains
quatrain1745823quatrain_
reattain846733reattain_
refrains1139593re_frains
restrain8311703restrain_
restraint9412753restraint
restraints1056603restraints
retains74522253re_t_ains
retrain7615423re_train_
safranins1244353s_afranins
sarans64224433s_a_ra_ns
sarins63932623s_a_r_ins
satins64930483s_at__ins
satrapies1147713s_atrapies
satraps95011643s_atra_ps
saurians837763s_aurians
savarins1139893s_avarins
seacrafts1443703seacrafts
seafaring1345963seafaring
seafarings1442783seafarings
sealskins1343253sealskins
searing83330923sea_r_ing
searobins1145553searobins
seastrand1043673seastra_nd
seastrands1143123seastrands
seatbacks17115603seatbacks
seating84130683seat__ing
seatings93614303seat__ings
seatmates1157823seatmates
seatrouts946393seatrouts
seawans10379943sea_wa_ns
sectarians1245833sectarians
sectaries11312243sectaries
seitans73312303seit_a_ns
sentries81318053sentr_ies
serails73318363se__rails
serais64326133se__rai_s
sereins73716113se__reins
serins64029673se__r_ins
sextain14257103sext_ain_
sextans14349263sext_a_ns
sextarius1644213sextarius
sprains93013593s__prains
stains64923653s__t_ains
statins73719773stat__ins
stearins8312143stea_r_ins
strain64919573s__train_
straits74916323s__traits
sustains838553sust_ains
suzerains1845733suzerains
terrains8410323te_rrains
trains64725343___trains
veratrins1247753veratr_ins
vitrains1138283_vitrains
zeatins16311733zeat__ins

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 Limit148641827.26620457.1
3Display Results82820.0332484.8
 (SQL Overall)178691827.75223051.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.