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

53 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
coagulation144727(None) 
coagulations1546511coagulations
coagulating1545072coagulating
congelation14410342congelation
copulation141111952co_pulation
adulation10311013__adulation
angulation1149553_angulation
calculation1548293calculation
caudation1269993c_a_udation
causation1199523c_a_usation
circulation1549393circulation
coagulate1258083coagulat__e
coagulated1496533coagulat_ed
coagulates13137453coagulat_es
coalition1148703coa__lition
coaptation1448343coa_ptation
coarctation1595073coarctation
coeducation1646233coeducation
cogitation13410083co_gitation
cognation12310753co_g_nation
collation11313993co__llation
commutation1748003commutation
compilation1749313compilation
computation1748713computation
confabulation2063303confabulation
conflation15412083co_nflation
confutation1668723confutation
congelations1549733congelations
conjugation2146623conjugation
conjuration2049513conjuration
consolation13410983consolation
consultation1447473consultation
copulations151111113co_pulations
correlation1358553correlation
corrugation1445993corrugation
crenulation1347573crenulation
cumulation1448173c_umulation
ejaculation2096133ejaculation
formulation1646363formulation
granulation1246553granulation
gratulation1245993gratulation
lobulation1247233lo_bulation
maculation14510983_maculation
modulation13147933mo_dulation
morulation12148903mo_rulation
nodulation11127993no_dulation
osculation1249673_osculation
ovulation1238983_o_vulation
population14810023po_pulation
postulation13119133postulation
regulation11312053_regulation
stagflation1553143stagflation
tabulation1247813_tabulation

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 Filter1786911216330.406440125.6
2DLD Change Limit121633536.56318533.1
3Display Results53530.0301766.7
 (SQL Overall)178691536.99925530.9
 
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.