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

114 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
commuting1628844(None) 
communing16207861communing
computing16309851computing
coempting1636072coempting
combating16310152combating
combusting1745442combusting
commenting1749172commenting
comminuting1844502comminuting
committing1746682committing
commixing2345192commixing
commoving1944982commoving
commutating1846022commutating
competing163712462competing
compting153013602co_mpting
confuting1539092confuting
campusing1654913campusing
cementing1438763cementing
chuting132910733c__huting
clouting113011683c_louting
coacting133412703co_acting
coaming123818323coam__ing
coapting133511613co_apting
coasting113615513co_asting
coating103525313co__ating
coediting1338333coediting
coequating2245323coequating
cohosting1546323cohosting
cohousing1535283cohousing
collating12312763collating
colleting12311053colleting
colluding1335903colluding
colouring1258733colouring
comaking1739993co_making
combatting1755133combatting
combing143714733co_m_bing
combining1637893combining
comforting18165933comforting
coming114225453co_m__ing
commanding1845923commanding
commencing1946183commencing
commending1846633commending
commercing1955973commercing
commotion1576983commotion
commotions1686843commotions
commune13329363commu__ne
communion1546363communion
communions1656183communions
communise1546803communise
communising1844963communising
communism1445633communism
communist1548113communist
community1846213community
communize2446283communize
communizing2745233communizing
commutate1547063commutate
commute134310443commut__e
commuted15288983commut_ed
commuter143010153commut_er
commuters15378913commuters
commutes143011893commut_es
compacting19177083compacting
comparing162410583comparing
comparting17188373comparting
compering163414163compering
compiling1637763compiling
comping143518593co_m_ping
completing1748413completing
complying1936113complying
comporting17199163comporting
composing16179843composing
composting17178043composting
computist1547323computist
conducing1537693conducing
conducting1648833conducting
confusing1537333confusing
conjuring1937913conjuring
connoting12310023connoting
consulting1349083consulting
consuming1437913consuming
contusing1239143contusing
coopting133411313co_opting
corrupting1555583corrupting
corseting12312173corseting
cosseting1239543cosseting
costing104323023co__sting
costuming1445283costuming
coting94629253co___ting
counting113115273co_unting
couping124317023co__uping
courting112514573co_urting
coveting141912303co_veting
cowriting1557323cowriting
cremating14312193cremating
fomenting1537233fomenting
gemmating1576443gemmating
grommeting1642913grommeting
immuring1335533_immuring
imputing1336853_imputing
louting83719383lo__uting
muting93921523___muting
omitting11217743_omitting
outing74128153_o__uting
permuting1446553permuting
polluting1235703polluting
pommeling1643873pommeling
pouting103519943po__uting
recomputing1844343recomputing
routing83821093ro__uting
scouting112612753sco__uting
summating1437943summating
summiting1445793summiting
tomming12359243tomm__ing
touting84118453to__uting
vomiting1437733vo_miting

Search took 10 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.1561145455.1
2DLD Change Limit1486411148.81316866.1
3Display Results1141140.0631809.5
 (SQL Overall)1786911149.03219784.2
 
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.