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

75 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
deaminations15101013(None) 
deamination14411541deamination_
delaminations1647941delaminations
damnations1337082d_am_nations
deaminating1547972deaminati_ng
declinations15410222declinations
delamination1548852delamination_
denominations16117852denominations
deracinations1647832deracinations
desalinations14410182desalinations
destinations13412662destinations
dominations14611042d_ominations
examinations2167462examinations
geminations14139252ge_minations
germinations15137942germinations
laminations1339802_laminations
terminations14149762terminations
abominations1646613abominations
brominations1646753brominations
comminations18810483comminations
criminations1648063criminations
culminations1646533culminations
damnation1238403d_am_nation_
darnations1138413d_a_rnations
deactivations19175063deactivations
deaerations12311673dea_erations
dealations11311373dea__lations
deaminates1349383deaminat__es
decapitations1847663decapitations
decimations16410163de_cimations
declination14411873declination_
dedications15310873de_dications
defamations1745893defam__ations
definitions1545603de_finitions
deifications18410653deifications
delaminating1645683delaminati_ng
delimitations1676633delimitations
delineations1346763de_lineations
demarcations1746123demarcations
denomination15118833denomination_
deoxidations2145243deoxidations
depilations14310903de_pilations
deprivations1897923deprivations
deracination1548863deracination_
derivations15611493de_rivations
desalination13411133desalination_
designations1456943designations
destination12413843destination_
determinations1766893determinations
detonations1239373de_tonations
deviations14311163de_vi_ations
diminutions1444543d_iminutions
divinations15128413d_ivinations
domination13712373d_omination_
eliminations1447613eliminations
emanations1289593_e_manations
evaginations1645823evaginations
examination2058453examination_
fulminations1745033fulminations
gemination131410653ge_mination_
germination14148973germination_
idealizations2379453idealizations
imaginations1546343imaginations
lamination12311223_lamination_
marinations13411273_marinations
nominations13410533_nominations
paginations1447753_paginations
patinations13411003_patinations
pectinations1649253pectinations
realizations21415533realizations
reanimations1468783reanimations
reexaminations23153413reexaminations
renominations15108303renominations
ruminations1349393_ruminations
termination131311163termination_

Search took 5 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 Filter178691950240.1261418182.5
2DLD Change Limit95024754.42021498.6
3Display Results75750.0332272.7
 (SQL Overall)178691754.57939024.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.