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

85 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
dentitions114885(None) 
dentations11413631dentations
dentition1049631dentition_
denotations1239852denotations
dentation10315242dentation_
detritions1148952detritions
lenitions939472len_itions
mentations12312582mentations
petitions11511082pe_titions
renditions1149182renditions
venditions1445522venditions
adventitious1652233adventitious
centillions1353973centillions
centurions1255513centurions
conditions13410103conditions
contritions13410913contritions
dealations11311373dealations
decantations1547943decantations
deceptions1547863deceptions
decisions1248383de_cisions
decoctions1547143decoctions
deconditions1645283deconditions
deductions1467133deductions
defections161510203defections
definitions1545603definitions
deflations1439713deflations
deglutitions1452153deglutitions
dejections20168353dejections
delations102616593de_lations
deletions102610933de_letions
demolitions1446523demolitions
demotions1258443de_motions
denegations1348543denegations
denotation11311083denotation_
densities10310793densiti_es
dentins83419223den__ti_ns
denudations1346343denudations
depictions1546893depictions
depletions1355743depletions
depositions14117683depositions
deputations1448343deputations
derisions1038843de_risions
desertions1139883desertions
destinations13412663destinations
destitutions1385253destitutions
detections131410043detections
detentions11148803detentions
detrition1049133detrition_
deviations14311163deviations
devotions1356593de_votions
dictations1389703dictations
dietitians1142953dietitians
donations101112353don_ations
dotations101411633d_otations
editions9310403_e_ditions
enations83316903_en_ations
entities8617413_entiti_es
envisions1245613_envisions
fenthions1544233fent_hions
fetations12511383fe_tations
gestations1139773gestations
identities1146953identiti_es
ignitions1045803ign_itions
indentations1347883indentations
intuitions1047293_intuitions
lenition8310083len_ition_
mentation11313983mentation_
mentions10312893men__tions
monitions11310883mon_itions
munitions1138173mun_itions
partitions1248323partitions
peltations12311553peltations
perditions1348873perditions
petition10711753pe_tition_
punitions1137923pun_itions
reeditions1147653reeditions
rendition1058933rendition_
repetitions1378023repetitions
restations10315843restations
seditions1039013se_ditions
sensations1059853sensations
sortitions1046423sortitions
venations12311723ven_ations
vendition1345693vendition_
ventilations1547403ventilations

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 Filter1786911406030.420425454.8
2DLD Change Limit140603858.19017167.6
3Display Results85850.0461847.8
 (SQL Overall)178691858.65620643.6
 
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.