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

189 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
competing16371246(None) 
compering163414161compering
completing1748421completing
compting153013601comp_ting
computing16309851computing
carpeting1439482carpeting
coapting133511612coap_ting
coempting1636072coemp_ting
colleting12311052colleting
combating16310162combating
commenting1749172commenting
commuting16288442commuting
compacting19177092compacting
comparing162410582comparing
comparting17188382comparting
compeering1747052compeering
compelling1746552compelling
competent15411252competent
compiling1637762compiling
comping143518592comp__ing
complecting2045762complecting
complexing2444742complexing
complying1936112complying
comporting17199162comporting
composing16179842composing
composting17178052composting
coopering142611322coopering
coopting133411312coop_ting
coppering162810892coppering
corseting12312172corseting
cosseting1239542cosseting
coveting141912302co_veting
bonneting1236173bonneting
bumpering1636593bumpering
cacheting1737153cacheting
cambering16109873cambering
cameoing1379063cam_eoing
campesino1544633campesino
camping143118973camp__ing
campusing1654913campusing
capering132414963c_apering
carpetings1544213carpetings
casketing1635383casketing
cementing1438763cementing
chomping18339883chomp__ing
choppering2064813choppering
clomping15329653clomp__ing
closeting1236183closeting
coacting133412703co_acting
coasting113615513co_asting
coating103525313co__ating
cockering1839693cockering
cocreating15310293cocreating
coediting1338333coediting
coerecting15218783coerecting
coexerting2045493coexerting
coffering1838043coffering
cohering142413833co_hering
cohosting1546323cohosting
collating12312763collating
collecting1548283collecting
comaking1739993com_aking
combatting1755143combatting
combing143714733com__bing
combining1637893combining
combusting1745453combusting
cometic131215723com_eti_c
comforting18165933comforting
coming114225453com___ing
commencing1946183commencing
commending1846633commending
commercing1955973commercing
committing1746683committing
commixing2345193commixing
commoving1944983commoving
communing16207863communing
companying2044813companying
compassing1746553compassing
compend144010303compe__nd
compensating1955003compensating
compete134716553compet__e
competed154113593compet_ed
competence1846723competence
competency2155043competency
competes144117243compet_es
competitor1653733competitor
complain1448763complain_
complains1549193complains
complaint15410253complaint
completion1647303completion
completions1746913completions
completive1946233completive
complin13312073comp_lin_
compline14313553comp_line
complins14313113comp_lins
complotting18124263complotting
compositing1846263compositing
compressing1846433compressing
comprising1748633comprising
comprizing2647463comprizing
computist1547323computist
conceding1559343conceding
conceiting15311773conceiting
concerting15313893concerting
concreting1539873concreting
confecting18310553confecting
confuting1539093confuting
congeeing1337903congeeing
congesting14410113congesting
connecting15310383connecting
connoting12310023connoting
consenting13313223consenting
contenting13313323contenting
contesting13312213contesting
convecting18310433convecting
convening15311193convening
conventing16311543conventing
converting16313133converting
conveying1838323conveying
cooeeing1137453co_oeeing
cooeying1438143co_oeying
cooperating1648423cooperating
cooping123918933coop__ing
coping113927663co_p__ing
coppicing1845403coppicing
copping143918593co_p_ping
copying153411983co_p_ying
coquetting2244513coquetting
corbeling1439033corbeling
cornering12311893cornering
correcting15199303correcting
coshering15510023coshering
costing104323023co__sting
coting94629253co___ting
counting113115273co_unting
couping124317023coup__ing
coupling13310783coup_ling
couponing1446293couponing
courting112514573co_urting
covering142215723co_vering
cowering142514033co_wering
cowriting1557323cowriting
cozening20188303co_zening
crocheting1844703crocheting
croqueting2243173croqueting
cumbering16108203cumbering
cupeling1338863c_upeling
curveting1535353curveting
dampening1535463dampening
docketing1785413docketing
fomenting1537233fomenting
gimleting1343863gimleting
grommeting1642913grommeting
hampering1738863hampering
homering141512073hom_ering
impeding1436563_impeding
imputing1336853_imputing
loppering14237283loppering
meeting103314963__meeting
meting94320593__m_eting
nonmeeting1346073nonmeeting
omening10310093_om_ening
omitting11217743_omitting
oompahing1773173oompahing
opening1039923_o_pening
opting94514403_o_p_ting
outcompeting1952283outcompeting
pampering1638383pampering
pocketing1875853pocketing
pommeling1643873pommeling
prompting1637203promp_ting
recomputing1844343recomputing
remeeting12311433remeeting
rocketing1666973rocketing
romping123113033romp__ing
roqueting1944603roqueting
scampering1745323scampering
simpering1449293simpering
socketing1666383socketing
something1545403som_ething
sonneting1037003sonneting
sopiting11310763so_piting
tampering1438453tampering
tempering1438733tempering
tempesting1544453tempesting
tempting1357343temp_ting
toileting1036263toileting
trumpeting1543573trumpeting
vomiting1437733vom_iting

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.470380193.6
2DLD Change Limit1486411897.48319863.8
3Display Results1891890.0932032.3
 (SQL Overall)1786911898.04622208.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.