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

94 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
destinies1041084(None) 
destines93619661destin_es
dentines93418402dentin_es
destine83719952destin_e_
destined103312452destin_ed
destining11311432destining
detinues9569822de_tinues
mestinoes1157312mestinoes
sestines82717242sestin_es
testifies12139262testifies
astonies8815093_astonies
beatifies1459283beatifies
bestiaries1245973bestiaries
betonies10413063be_tonies
certifies14310323certifies
cystines1339473cystin_es
deaminizes2246803deaminizes
declines113315803declin_es
defines114118683de_fin_es
definiens1345303de_finiens
deifies113317453de__ifies
deities82621923de__ities
delaines9312963delain_es
demystifies2052373demystifies
denies74729643de___nies
densifies1347993densifies
densities10310793densities
denticles1237753denticles
dentine83320243dentin_e_
dentins83419223dentin__s
desalinizes2144143desalinizes
descries11311923des_cries
desertifies1544703desertifies
designees1145003designees
desires81316133des_i_res
despises1139433despi_ses
despites11410313despi_tes
destained1158253destain_ed
destaining1267943destaining
destains9311813dest_ains
destiny113111463destin__y
destitutes1156523destitutes
destrier9311823dest_rier
destriers1038143dest_riers
detainees10267153detainees
detentes92712873de_tentes
detinue85010033de_tinue_
dextrines1798313dextrin_es
diclinies1247833diclinies
distances12311653distances
dittanies1045733dittanies
dominies113513193d_ominies
dustiness102211033dustiness
dustings10419033dustin_gs
dystonias1345263dystonias
entities8617413_entities
festinates1348943festinates
heinies102514543he__inies
identifies1445803identifies
identities1146953identities
jestings16368023jestin_gs
justifies1945793justifies
meinies92516073me__inies
mestinos1048163mestin_os
mestizoes2064173mestizoes
mutinies10311503_mutinies
mystifies1745883mystifies
neotenies948383neotenies
pectines121914683pectin_es
pesticides1546723pesticides
rectifies14310813rectifies
reshines112615443reshin_es
restudies10156033restudies
retines75134673re_tin_es
retinites9313503re_tinites
retinues85113153re_tinues
serotinies1047443serotinies
sestinas8249133sestin_as
sestine73017923sestin_e_
stimies9316563__stimies
testacies1148373testacies
testicles1146773testicles
testified1397843testified
testifier12116893testifier
testifiers13124503testifiers
testimonies1352693testimonies
testiness9209753testiness
tetanies8513553te_tanies
vastities1248933vastities
vestiaries1345373vestiaries
vestiges1238243vesti_ges
vestings12359143vestin_gs
vestries11314053vest_ries
westings12429803westin_gs

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 Filter1786911486410.436409841.7
2DLD Change Limit148641946.37623312.6
3Display Results94940.0462043.5
 (SQL Overall)178691946.85826055.8
 
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.