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

118 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
distained113960(None) 
destained1158251destained
disdained1246021disdained
distrained1257671distrained
abstained1245052abstained
destined103312452dest_ined
detained103111642d_etained
disjoined1845832disjoined
distain8313782distain__
distains9413602distain_s
distanced1348572distanced
distasted1137962distasted
distrainer1146432distrainer
mistrained1347582mistrained
stained84215342__stained
sustained1045382sustained
unstained1038682unstained
abstainer1144403abstainer
attained997353_attained
captained1446193captained
contained12310893contained
curtained1265503curtained
despaired1344503despaired
destain8412083destain__
destains9311813destain_s
destine83719953dest_ine_
destines93619663dest_ines
detailed10319873d_etailed
detainee92511723d_etainee
detainer92910793d_etainer
detrained1158913detrained
dictated1239203dicta_ted
dirtied93210853dirt_i_ed
disabled1248713dis_abled
disarmed1238643dis_armed
disband1138243disba_n_d
disbanded1445643disbanded
disbarred1345273disbarred
discalced1545653discalced
discanted1339333discanted
discarded1437083discarded
discased122510853disca_sed
discerned1347863discerned
disclaimed1644413disclaimed
disdain938513disdain__
disdains1037913disdain_s
diseased103011713disea_sed
disentailed1354603disentailed
disguised1245973disguised
disjointed1944833disjointed
disliked14288553dis_liked
dislimned1344623dislimned
dismasted1346833dismasted
dismayed1535743disma_yed
disowned1336433dis_owned
disparted1338853disparted
dispraised1446403dispraised
disprized2247363disprized
disrated10915573disra_ted
dissaved1337313dissa_ved
disseised1147863disseised
disseized2046323disseized
distaining1248903distaining
distance11311853dista_nce
distances12311653distances
distant83519953dista_n_t
distaste939943distaste_
distastes1039633distastes
distaves12311403dista_ves
distend93312073dist_en_d
distended12157923distended
distilled1147173distilled
distinct11410763dist_inct
distorted1139373distorted
distracted1448873distracted
distrain9412243distrain__
distrainers1255053distrainers
distrainor1163393distrainor
distrains10411333distrain_s
distraint101112903distrain_t
distraints1166873distraints
distraite10611483distraite_
districted1448223districted
disturbed13195583disturbed
disunited1177273disunited
disvalued1444193disvalued
dittanies1045733dittanies
divined12329693di__vined
drained93713253d__rained
fishtailed1741863fishtailed
histamine1476903histamine_
histamines1575893histamines
intwined1235463_intwined
isatine7311763_isatine_
isatines8310663_isatines
listened9168813list_ened
maintained1343853maintained
misaimed1338093mis_aimed
misatoned1246693misatoned
miscoined1448443miscoined
misjoined1945453misjoined
mispainted1545013mispainted
misraised1268313misraised
mistimed1339123mist_imed
mistuned1157723mist_uned
obtained1136533_obtained
pertained1238503pertained
pigtailed1353493pigtailed
pintailed1245553pintailed
restrained1148413restrained
retained93016093_retained
sained75424243__s_ained
stainer73614923__stainer
staned74824643__sta_ned
strained9412253__strained
sustainer944783sustainer
unstrained1146373unstrained
vistaed1138023vista__ed

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411187.29620372.9
3Display Results1181180.0502360.0
 (SQL Overall)1786911187.76623009.4
 
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.