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

104 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
distances1231165(None) 
distance11311851distance_
distanced1348571distanced
desistances1444192desistances
distastes1039632distastes
distaves12311402dista_ves
dittanies1045732dittanies
instances1148752instances
pittances1345702pittances
stances93715962__stances
acutances1345763acutances
admittances1652073admittances
assistances1353053assistances
brisances1345843bris_ances
dances95120653d___ances
defiances1557033defiances
desistance1344583desistance_
destines93619663destin_es
destinies10410843destinies
deviances1566493deviances
diamantes1296263diamantes
diastases1047073diasta_ses
dictates11311383dicta_tes
dietaries10410663dietaries
dilatancies1453253dilatancies
dioxanes1645373dioxan_es
disables11410903dis_ables
disbanded1445643disbanded
disbands1237353disban_ds
disbranches1953523disbranches
discalced1545653discalced
discanted1339333discanted
discants112912023discan_ts
discases112014503disca_ses
diseases92415813disea_ses
disgraces1348453disgraces
disjuncts1942723disjuncts
dismantles1344333dismantles
dispatches1874583dispatches
dispenses121210763dispenses
displaces1448593displaces
disrates91118153disra_tes
dissaves1239413dissa_ves
dissonances1454273dissonances
distaffs1565083dista_ffs
distained1139603distained
distains9413603dista_ins
distancing1447083distancing
distant83519953distan__t
distantly1346393distantly
distantness1254343distantness
distaste939943distaste_
distasted1137963distasted
distended12157923distended
distender11167743distender
distenders12166743distenders
distends10339823disten_ds
distichs1447633dist_ichs
distinct11410763distinc_t
distincter1345303distincter
distinctest1454973distinctest
distomes11314163dist_omes
distracts1249293distracts
districts1248943districts
disturbances1752453disturbances
disvalues1344503disvalues
durances1158683d_urances
emittances1443823emittances
existences1944823existences
fiances12310673fi__ances
finances1338663fi_nances
hesitances1545543hesitances
histones11312803histon_es
instance1049883instance_
instanced1245703instanced
instancies1246613instancies
issuances1144643issuances
laitances1145613laitances
litanies8310993li_tanies
militances1445683militances
mischances1946373mischances
mistakes141213413mista_kes
mistraces13312293mistraces
mistunes10311133mistun_es
naissances1243423naissances
nuisances1145333nuis_ances
outdistances1551763outdistances
piquances2244053piquances
pistaches1646673pistaches
pittance1246113pittance_
portances1349833portances
pristanes11410433pristan_es
puissances1443303puissances
quittances2143203quittances
resistances1345373resistances
riddances1343893riddances
seances93015343__seances
stance84316913__stance_
stanches132312793__stanches
stanes64933403__stan_es
substances1446323substances
tisanes7311853tis_an_es
usances967373_us_ances
vibrances1645763vibrances

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.450397091.1
2DLD Change Limit1486411047.70619289.0
3Display Results1041040.0462260.9
 (SQL Overall)1786911048.20221786.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.