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

66 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
mestinoes115731(None) 
mestinos1048161mestino_s
mestizoes2064171mestizoes
destines93619662destin_es
destinies10410842destinies
mestesoes1145322mestesoes
mestino9411642mestino__
mestizos1944492mestizo_s
sestines82717242sestin_es
cystines1339473cystin_es
dentines93418403dentin_es
destine83719953destin_e_
destined103312453destin_ed
detinues9569823de_tinues
emetines10611053emetin_es
estrones8313323_estrones
festinates1348943festinates
jestings16368023jestin_gs
mastiches1647333mastiches
mastixes1738253masti_xes
matinees102110423m_atinees
meatiness11311183meatiness
meetings11287413meetin_gs
meinies92516073me__inies
meninges1137433me_ninges
mentioned1246833mentioned
mentioner1146693mentioner
mentioners1245343mentioners
mentions10312893menti_ons
merinos9311983me_rino_s
mesnes85216213mes__n_es
messiness11248223messiness
mestees94617753mest__ees
mestesos1045223mesteso_s
mestizas1944703mesti_zas
mestizo1845943mestizo__
mestranols1243273mestranols
metisses1036833me_tisses
mistimes12612613misti_mes
mistiness111911633mistiness
mistitles1147953mistitles
mistunes10311133mistun_es
mustiness112211663mustiness
mutines93117823m_utin_es
mutinies10311503m_utinies
mutinous1047653m_utinous
mystifies1745883mystifies
mystiques2342423mystiques
oestrones949773oestrones
pectines121914683pectin_es
pectinous1345553pectinous
pettitoes1144183pettitoes
reshines112615443reshin_es
resinous838503res_inous
retines75134673re_tin_es
retinols8419743re_tinols
retinues85113153re_tinues
sestinas8249133sestin_as
sestine73017923sestin_e_
testicles1146773testicles
testifies12139263testifies
testiness9209753testiness
vertigoes1354703vertigoes
vestiges1238243vesti_ges
vestings12359143vestin_gs
westings12429803westin_gs

Search took 9 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.423422437.4
2DLD Change Limit148641667.67319372.0
3Display Results66660.0302200.0
 (SQL Overall)178691668.12621990.0
 
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.