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

131 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
computing1630985(None) 
commuting16288441commuting
competing163712461competing
compting153013601comp_ting
campusing1654912campusing
coapting133511612coap_ting
coempting1636072coemp_ting
combating16310162combating
combusting1745452combusting
communing16207862communing
compacting19177092compacting
comparing162410582comparing
comparting17188382comparting
compering163414162compering
compiling1637762compiling
comping143518592comp__ing
completing1748422completing
complying1936112complying
comporting17199162comporting
composing16179842composing
composting17178052composting
computist1547322computist
confuting1539092confuting
coopting133411312coop_ting
imputing1336852_imputing
recomputing1844342recomputing
camping143118973camp__ing
carpeting1439483carpeting
cementing1438763cementing
chomping18339883chomp__ing
chuting132910733c__huting
clomping15329653clomp__ing
clouting113011683c_louting
coacting133412703co_acting
coasting113615513co_asting
coating103525313co__ating
coediting1338333coediting
coequating2245323coequating
cohosting1546323cohosting
cohousing1535283cohousing
collating12312763collating
colleting12311053colleting
colluding1335903colluding
colouring1258733colouring
comaking1739993com_aking
combatting1755143combatting
combing143714733com__bing
combining1637893combining
comforting18165933comforting
coming114225453com___ing
commenting1749173commenting
comminuting1844503comminuting
committing1746683committing
commixing2345193commixing
commoving1944983commoving
commutating1846023commutating
companying2044813companying
compassing1746553compassing
compeering1747053compeering
compelling1746553compelling
competent15411253competent
complain1448763complain_
complains1549193complains
complaint15410253complaint
complecting2045763complecting
complexing2444743complexing
complin13312073comp_lin_
compline14313553comp_line
complins14313113comp_lins
complotting18124263complotting
compositing1846263compositing
compounding1943073compounding
comprising1748633comprising
comprizing2647463comprizing
compute134513663comput__e
computed154110953comput_ed
computer144511513comput_er
computers15339753computers
computes143914553comput_es
computists1644693computists
conducing1537693conducing
conducting1648833conducting
confusing1537333confusing
conjuring1937913conjuring
connoting12310023connoting
consulting1349083consulting
consuming1437913consuming
contusing1239143contusing
coopering142611323coopering
cooping123918933coop__ing
coping113927663co_p__ing
coppering162810893coppering
coppicing1845403coppicing
copping143918593co_p_ping
copulating1549373co_pulating
copying153411983co_p_ying
corrupting1555583corrupting
corseting12312173corseting
cosseting1239543cosseting
costing104323023co__sting
costuming1445283costuming
coting94629253co___ting
counting113115273co_unting
couping124317023co__uping
coupling13310783coup_ling
couponing1446293couponing
courting112514573co_urting
coveting141912303co_veting
cowriting1557323cowriting
deputing12238793_deputing
disputing1337763disputing
fomenting1537233fomenting
louting83719383lo__uting
miscomputing2152753miscomputing
muting93921523__m_uting
omitting11217743_omitting
oompahing1773173oompahing
opting94514403_o_p_ting
outing74128153_o__uting
polluting1235703polluting
pouting103519943po__uting
precomputing2153273precomputing
prompting1637203promp_ting
reputing112412603_reputing
romping123113033romp__ing
routing83821093ro__uting
scouting112612753sco__uting
sopiting11310763so_piting
tempting1357343temp_ting
touting84118453to__uting
vomiting1437733vom_iting

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.420425454.8
2DLD Change Limit1486411317.12620859.0
3Display Results1311310.0602183.3
 (SQL Overall)1786911317.60623493.4
 
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.