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

112 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
mistrains1151135(None) 
distrains10411331distrains
mistrain10311941mistrain_
distains9413602dist_ains
distrain9412242distrain_
distraint101112902distraint
distraints1166872distraints
midbrains1443712midbrains
mistraces13312292mistraces
mistracing1569602mistracing
mistrained1347582mistrained
mistrals101212632mistra_ls
mistrials1148142mistrials
restrains9311622restrains
strains74218152__strains
vitrains1138282vi_trains
abstains1047323abst_ains
cistrons102710623cistr_ons
citrins92614363ci_tr_ins
constrains1249723constrains
destains9311813dest_ains
detrains9411763_detrains
disdains1037913dis_dains
distain8313783dist_ain_
distracts1249283distracts
distrained1257673distrained
distrainer1146433distrainer
distrainers1255053distrainers
distrainor1163393distrainor
distrainors1252923distrainors
distrait9414343distrai_t
distraite10611483distraite
entrains8312963_entrains
estrins7315853_estr_ins
eyestrains1343563eyestrains
gastrins9310123gastr_ins
histamins1476723histamins
histidins1345073histidins
historians13106303historians
ingrains948983_ingrains
maintains1167103maint_ains
midbrain1343923midbrain_
migraine1157863mi_graine
migraines1286933mi_graines
mirins83918903mi__r_ins
misaims11310113mis__aims
misbegins1444893misbegins
misbrand1346413misbra_nd
misbrands1445153misbrands
misclaims1544593misclaims
miscoins12311083mis_coins
misdrawing1745803misdrawing
misdrawn1444343misdrawn_
misdraws1445753misdra_ws
miseries10320403miser_ies
misframes1646633misframes
misframing1846233misframing
misgrades1347363misgrades
misgrading1546823misgrading
misgrafts1544293misgrafts
misjoins1736913mis_joins
mislain9311243mis_lain_
mislearns1144523mislearns
mispaint121111893mis_paint
mispaints13106183mis_paints
misplans1238863mispla_ns
misprint12912973mispr_int
misprints13107223mispr_ints
misraise10410523mis_raise
misraises1149933mis_raises
misrates101318243mis_rates
misrating121014853mis_rating
mistakes141213413mist_akes
mistaking1699693mistaking
misterming1538603misterming
misthink1745433mist_hink
misthinks1843353mist_hinks
mistiming1438913mistiming
misting103623383mist__ing
mistrace12312643mistra_ce
mistraced1439453mistraced
mistraining1446503mistraining
mistral91013643mistra__l
mistreating1449283mistreating
mistreats1148633mistreats
mistress10310703mistr_ess
mistrial10311383mistr_ial
mistrusts1146013mistrusts
mistruths1443683mistruths
mistrysts1443863mistrysts
mistuning1237673mistuning
mistyping1744723mistyping
mitring103514143mi_tr_ing
mortmains1344493mortmains
murrains1036853m_urrains
oestrins8312673oestr_ins
pretrains11410143pretrains
quatrains1845583quatrains
restrain8311703restrain_
restraint9412753restraint
restraints1056603restraints
retrains8314533_retrains
ristras7311563ristra__s
seatrains947603seatrains
sprains93013593__sprains
stains64923653__st_ains
strain64919573__strain_
straits74916323__straits
sustains838553sust_ains
trains64725343___trains
vitrain1038943vi_train_
wistarias1246793wistarias

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.403443402.0
2DLD Change Limit1486411127.01621186.0
3Display Results1121120.0631777.8
 (SQL Overall)1786911127.48223882.8
 
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.