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

91 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
mestizo184594(None) 
mestino9411641mestino
mestiza1835381mestiza
mestizos1944491mestizos
mesteso937132mesteso
mestinos1048162mestinos
mestizas1944702mestizas
mestizoes2064172mestizoes
bestial9311643bestial
besting104923923besting
bestir8311163besti_r
bestirs9311133bestirs
centimo11609543centimo
cesti75217423cesti__
destine83719953destine
destiny113111463destiny
festive1339773festive
gestapo1044493gestapo
gestic9312773gesti_c
jesting154317713jesting
lentigo846063lentigo
maestoso1053203maestoso
maestro945723maest_ro
mastic103119173masti_c
mastics112614783mastics
mastiff1538163mastiff
masting104325823masting
mastix152310513masti_x
matzo16312893m_at_zo
meatier93214613meatier
meatily12311093meatily
medico113711163me_dico
meeting103314963meeting
melting103317753melting
mendigo11506333mendigo
mention9314373mention
merino8315093me_rino
meshier123410853meshier
meshing134513813meshing
mesial84818083mes_ial
mesian84315503mes_ian
mesic93617863mes_i_c
messiah1246793messiah
messier93412923messier
messily12298813messily
messing103916393messing
mestee84523883mest_ee
mestees94617753mestees
mestesos1045223mestesos
mestinoes1157313mestinoes
metazoa1845543me_tazoa
metier83517693me_tier
meting94320593me_ting
metis75025903me_ti_s
metro74718803me_t_ro
mezzo1537433me__zzo
mistier93418713mistier
mistily122612343mistily
mistime11312613mistime
misting103623383misting
mustier94017963mustier
mustily123613633mustily
musting103221073musting
mystic132711643mysti_c
mystics14279103mystics
mystify1843563mystify
nesting84320443nesting
pectize20259913pectize
peptize20279483peptize
pestier94317403pestier
pesto75723723pest__o
reseize1639553reseize
resize154117723res_ize
resting85031183resting
restive10315933restive
sentimo9449623sentimo
sestina72711973sestina
sestine73017923sestine
testier74015643testier
testify13246943testify
testily102910803testily
testing86021053testing
testis64916713testi_s
testudo843363testudo
vertigo1146133vertigo
vestige1137433vestige
vesting114618683vesting
westing115020273westing
zestier163010223zestier
zestily19167563zestily
zesting174515333zesting

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit134027916.48320673.6
3Display Results91910.0303033.3
 (SQL Overall)178691916.91925826.1
 
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.