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

108 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
coempting163607(None) 
compting153013601co_mpting
coapting133511612co_apting
coediting1338332coediting
commuting16288442commuting
competing163712462co_mpeting
comping143518592co_mp_ing
computing16309852co_mputing
coopting133411312co_opting
cremating14312202cremating
exempting2144222exempting
tempting1357342_tempting
accepting1695803acce_pting
attempting1542923attempting
camping143118973c_amp_ing
cementing1438763c_ementing
champing183610933champ_ing
cheating144014523che_ating
cheeping16329553cheep_ing
chelating1549363chelating
chomping18339883chomp_ing
chumping18349063chump_ing
clamping154011153clamp_ing
cleating113518143cle_ating
clefting14347583cle_fting
cleping123310423cle_p_ing
clomping15329653clomp_ing
clumping15319883clump_ing
coacting133412703co_acting
coaming123818323coam__ing
coasting113615513co_asting
coating103525313co__ating
coemploying2152413coemploying
coempt12311033coempt___
coempted1535333coempt_ed
coempts1335683coempt__s
coenacting1545873coenacting
coequating2245323coequating
coercing1349003coe_rcing
coerecting15218783coerecting
coexerting2045493coexerting
coexisting2044403coexisting
cohosting1546323cohosting
collating12312783collating
colleting12311063colleting
comaking1739993co_making
combating16310163combating
combing143714733co_m_bing
coming114225453co_m__ing
commenting1749173commenting
committing1746683committing
commixing2345193commixing
commoving1944983commoving
communing16207863communing
compacting19177093co_mpacting
comparing162410583co_mparing
comparting17188383co_mparting
compering163414163co_mpering
compiling1637763co_mpiling
completing1748423co_mpleting
complin13312073co_mplin_
compline14313553co_mpline
complins14313113co_mplins
complying1936113co_mplying
comporting17199163co_mporting
composing16179843co_mposing
composting17178053co_mposting
confuting1539093confuting
connoting12310023connoting
cooping123918933co_op_ing
coping113927663co__p_ing
copping143918593co__pping
copying153411983co__pying
corelating13511583corelating
corrupting1555583corrupting
corseting12312173corseting
cosseting1239543cosseting
costing104323023co__sting
coting94629253co___ting
counting113115273co_unting
couping124317023co_up_ing
coupling13310783co_upling
courting112514573co_urting
coveting141912303co_veting
cowriting1557323cowriting
cramping153411853cramp_ing
creating113921953cre_ating
crediting1338843crediting
creeping133310103creep_ing
creping122913653cre_p_ing
cresting114017043cre_sting
crimping15299783crimp_ing
crimpling1645343crimpling
crumping15319903crump_ing
crumpling1645323crumpling
demoting12311423_demoting
emoting10313563__emoting
emptings1364823__emptings
emptins1179403__emptins
emptying1634243__emptying
fomenting1537233fomenting
opting94514403_o__pting
preempting1745393preempting
prompting1637203prompting
remating112322423_remating
romping123113033ro_mp_ing
temping122710693_temp_ing
vomiting1437733vo_miting

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411086.62322443.2
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.07525256.7
 
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.