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

163 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
metrists103985(None) 
metrist9317061metrist_
centrists11410232centrists
merises93421422me_rises
merisis93213172me_risis
merits8320872me_ri_ts
metalists11412662metalists
metrics11312362metri_cs
metritis1049182metritis
motorists1149912motorists
retwists1135602retwists
verists103613672ve_rists
altoists848753altoists
altruists945413altruists
amethysts1751623amethysts
amorists10411333amorists
aorists74215833_aorists
artists74215593art_ists
astricts1049463astricts
attrits7310613attri_ts
aurists74615783_aurists
autists73814853aut_ists
becrusts1244843becrusts
bemists113410703be_mists
betises94816123bet_ises
cellists1038563cellists
centrisms1348053centrisms
centrist10314863centrist_
cerises94722253ce_rises
czarists1966223czarists
defrosts1244833defrosts
deists74916433de__ists
delists84414173de_lists
dentists939263dentists
denturists1145353denturists
derrises93012783derrises
desists83611723de_sists
detests83711743det_ests
detracts11138833detracts
detritus945473detritus
diarists9410363diarists
duettists1043043duettists
egoists887073_egoists
emprises12311003emprises
enlists749393_enlists
entrusts847113entrusts
entwists1156143entwists
exists134710913_e_xists
feists94915313fe__ists
feudists1244463feudists
florists1138813florists
futurists1245583futurists
grists74716483__grists
heists96814633he__ists
heriots10312063he_riots
intrusts837723intrusts
intwists1145593intwists
jurists14409123_jurists
leftists11235513leftists
legists899593le_gists
lutists73810273lut_ists
lyrists1036963_lyrists
maists85817573m__aists
matrass939403matras_s
matrices12312083matrices
matrixes1738063matrixes
medalists1249373medalists
meerkats1443453meerkats
megrims1276103megri_ms
melanists1148623melanists
meliorists1245983meliorists
melodists1246633melodists
memoirists1444133memoirists
memorises131211583memorises
mentalists12410483mentalists
merest84725113me_rest_
merinos9311983me_rinos
meristem1245743me_ristem
meristems1343553me_ristems
meristic12311253me_ristic
merit7339183me_ri_t_
merlots92710123me_rlots
merriest10311473merriest_
mesmerists1444063mesmerists
metalises11315073metalises
metalist10519353metalist_
metallists1266713metallists
methinks1775193methinks
methodists1644973methodists
metiers93312843met_iers
metis75025903met_i__s
metisse936503met_isse
metisses1036833metisses
metres85121563metr__es
metric10314673metri__c
metrical12311593metrical
metricate1349913metricate
metricates1449113metricates
metricism1557513metricism
metricisms1646523metricisms
metrifies1439803metrifies
metrify1535623metri_fy
metring103215293metri_ng
metritises1247283metritises
metros84217803metr__os
midlists1137523midlists
mistrusts1146013mistrusts
mistrysts1443863mistrysts
mists76633903m___ists
mitises9315543mit_ises
monetarists1355613monetarists
monists93614783m_onists
morrises10711073morrises
mortises10713613mortises
motorises11311673motorises
motorist10314413motorist_
mutisms11338453mut_isms
naturists947513naturists
patriots1038053patriots
persists1049183persists
pietists1038323piet_ists
purists94014073_purists
querists1736543querists
realists83014843realists
relists73817053re_lists
reprints1039903reprints
reprises102615463reprises
rerises73525883re_rises
resists74414923re_sists
restricts1138823restricts
retests73813853ret_ests
retints74717013ret_ints
retracts101111313retracts
retreats8311413retreats
retrials8510823retrials
retries74129073retri_es
retrims93612373retri_ms
retwist1039483retwist_
revuists1135153revuists
sacrists1039563sacrists
satirists958923satirists
sexists14267673se_xists
sitarists949373sitarists
tennists8297793tennists
tenorists948193tenorists
territs72714503terri_ts
tetris62816293tetri__s
theorists1246603theorists
titlists837293titlists
tourists838313tourists
triste63818643__triste
trusts64714433__trusts
trysts9448793__trysts
tsarists857303tsarists
twists9549753__twists
tzarists1755693tzarists
ultraists947333ultraists
untwists1144623untwists
verisms123011253ve_risms
verist93823893ve_rist_
versts93914733ve_r_sts
votarists1298603votarists
wrists95415643__wrists

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.1561145455.1
2DLD Change Limit1461621637.04620744.0
3Display Results1631630.0602716.7
 (SQL Overall)1786911637.26224606.3
 
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.