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

75 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
mistreated134842(None) 
miscreated1547421miscreated
estreated1039562_estreated
intreated10312662_intreated
maltreated13125152maltreated
miscreate1348892miscreate_
miscreates1448102miscreates
misrated111315382mis_r_ated
misrelated1346492mis_related
misseated12610112mis_seated
mistraced1439452mistr_aced
mistreat10313112mistreat__
mistreats1148632mistreat_s
mistrusted1345432mistrusted
mistrysted1643632mistrysted
castrated1239523castr_ated
citrated112712253ci_tr_ated
disrated10915573dis_r_ated
disrelated1247343dis_related
disseated11711083dis_seated
distracted1448873distracted
distressed1246443distressed
districted1448223districted
distrusted1246293distrusted
entreated10310973_entreated
filtrated1345963filtr_ated
iterated91213833_i_terated
lustrated1037973lustr_ated
mainstreamed1751383mainstreamed
maltreater12124753maltreater
mastheaded1743543mastheaded
masticated1548233masticated
masturbated1652813masturbated
menstruated1473743menstruated
micturated1584993micturated
migrated121110513mi_gr_ated
minareted1244623minare_ted
misdated121211123mis__dated
misdirected1752463misdirected
miseaten10310773mis__eaten
misframed1745623misfr_amed
misgraded1446233misgr_aded
misgrafted1743793misgrafted
misleared1277453mis_leared
mislocated15196253mislocated
mismated131111333mis__mated
misoriented1453943misoriented
mispleaded1644133mispleaded
misprinted1545983misprinted
misrate91319143mis_r_ate_
misrates101318243mis_r_ates
misread10339723mis_rea__d
misrelate1147933mis_relate_
misrelates1247623mis_relates
misrelied1247243mis_relied
misrouted1247303mis_routed
misstated1278973mis_stated
mistended13137333mist_ended
mistermed1438363mist_ermed
mistrace12312643mistr_ace_
mistraces13312293mistr_aces
mistrained1347583mistrained
mistreating1449283mistreating
mistreatment1653443mistreatment
mistresses1247993mistresses
mitigated1347083mi_tigated
nitrated92213153ni_tr_ated
pretreated1347633pretreated
retreated10312633_retreated
streaked13228453__streaked
streamed11258903__streamed
striated93414153__striated
titrated92611683ti_tr_ated
treated83618703___treated
untreated10312913_untreated

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 Filter1786911406030.423422437.4
2DLD Change Limit140603756.92020318.4
3Display Results75750.0461630.4
 (SQL Overall)178691757.38924183.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.