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

120 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
mistreat1031311(None) 
mistreats1148631mistreats
estreat7314812_estreat
intreat7416302_intreat
maltreat1048652maltreat
midstream1443572midstream
miscreant1347572miscreant
miscreate1348892miscreate
miseat82925712mis__eat
misread10339722mis_read
misseat93617242mis_seat
mistiest103018312mistiest
mistral91013642mistr_al
mistreated1348422mistreated
mistress10310702mistress
mistrial10311382mistrial
mistrust1049202mistrust
mistryst1345842mistryst
airstream1153543airstream
bistre83815023bistre__
bistred103311853bistre_d
bistres94017213bistre_s
bitstream1342583bitstream
bystreet1345023bystreet
discreet11413183discreet
dispread1247103dispread
disseat83816923dis_seat
distent84120853dist_ent
distract11313023distract
distrait9414343distrait
distress9311713distress
district11413873district
distrust949953distrust
entreat7315263_entreat
estreats839423_estreats
gastrea847243gastrea_
gastreas957263gastreas
intreats8311543_intreats
mainstream1452733mainstream
maltreats1145223maltreats
masthead1435883masthead
midstreams1542573midstreams
millstream1461973millstream
miltiest103015173miltiest
minaret9520683minare_t
minstrel1046913minstre_l
minstrels1145693minstrels
mintiest103217143mintiest
misagent11410723misagent
miscreants1445083miscreants
miscreated1547423miscreated
miscreates1448103miscreates
misdeal1037663mis_deal
misdealt1147983mis_dealt
misdirect1444293misdirect
misdraw1345623misdr_aw
misdrew1335833misdre_w
miseats92815793mis__eats
miserere1049273miserere
misevent1349223misevent
misgraft1447203misgraft
misgrew1335523misgre_w
mishear1238393mis_hear
miskept1538923mis_kept
mislead10419973mis_lead
mismeet113215163mis_meet
mismet103722373mis_me_t
misorient11510893misorient
misplead1345023misplead
misprint12912973misprint
misrate91319143mis_r_ate
misreads11268923mis_reads
misrelate1147933mis_relate
misrely12319613mis_rely
misseats104011683mis_seats
missent94318713mis_sent
misset85028153mis_se_t
misspeak1643493misspeak
misspelt1247273misspelt
misspent1259173misspent
misteach1545443mist_each
misted93625823mist_e_d
mistend103812523mist_end
mister84728563mist_e_r
misterm114314513mist_erm
misterms123711353misterms
misters93927513mist_ers
misteuk1335893mist_euk
misthrew16124763misthre_w
mistier93418713mistie_r
mistrace12312643mistrace
mistrain10311943mistrain
mistrals101212633mistrals
mistreating1449283mistreating
mistrials1148143mistrials
mistrusts1146013mistrusts
mistruth1346043mistruth
mistrysts1443863mistrysts
miswrit1249413miswr_it
mitiest93520053mi_tiest
mitral81314323mi_tr_al
mitre75522423mi_tre__
mitred94414343mi_tre_d
mitres83922073mi_tre_s
moistest1038763moist_est
mostest9314793most_est
muskrat1346733muskr_at
mustiest103017533mustiest
onstream1045113onstream
postheat13411243postheat
pretreat10311923pretreat
retreat7317533_retreat
ristra6310713ristr_a_
ristras7311563ristr_as
sistra639333sistr_a_
streak104613623__streak
stream84717293__stream
street64125773__street
treat56240353___treat
upstream1243553upstream

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.420425454.8
2DLD Change Limit1461621206.80021494.4
3Display Results1201200.0462608.7
 (SQL Overall)1786911207.26624592.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.