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

154 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
comparing16241058(None) 
comparting17188371comparting
compering163414161compering
collaring12310542collaring
comaking1739992com_aking
combating16310152combating
compacting19177082compacting
companying2044812companying
compassing1746542compassing
compeering1747052compeering
competing163712462competing
compiling1637762compiling
comping143518592comp__ing
complying1936112complying
comporting17199162comporting
composing16179842composing
compting153013602comp_ting
computing16309852computing
coopering142611322coopering
coppering162810892coppering
oompahing1773172oompahing
bombarding1843833bombarding
bumpering1636593bumpering
cambering16109873cambering
campaign1544213campa_ign
camping143118973camp__ing
campusing1654913campusing
capering132414963c_apering
caring95137993c___aring
cellaring1238523cellaring
charing133721323c__haring
chomping18339883chomp__ing
choppering2064813choppering
clearing113014883c_learing
clomping15329653clomp__ing
coaling103722823co__aling
coaming123818323co__aming
coappearing1842763coappearing
coapting133511613coap_ting
coating103525313co__ating
coaxing173511703co__axing
cochairing1844653cochairing
cockering1839693cockering
coempting1636073coemp_ting
coffering1838043coffering
coheading1636623coheading
cohering142413833co_hering
coleading1338523coleading
collaging1337913collaging
collating12312763collating
coloring11414843co_loring
colouring1258733colouring
comanaging1644323comanaging
combatting1755133combatting
combing143714733com__bing
combining1637893combining
comforting18165933comforting
coming114225453com___ing
commanding1845923commanding
commercing1955973commercing
commixing2345193commixing
commoving1944983commoving
communing16207863communing
commuting16288443commuting
companied1648023companied
companies15311803companies
companion1577683companion
companions1697263companions
company1619711143compa__ny
compare135814993compar__e
compared153811823compar_ed
comparer143611363compar_er
comparers15319393comparers
compares143816433compar_es
comparison1644353comparison
comparisons1753973comparisons
compart134016003compar__t
comparted16338423comparted
comparts144210833compar_ts
compatriot1655963compatriot
compelling1746553compelling
complain1448753complain_
complaining1844723complaining
complains1549183complains
complaint15410243complaint
completing1748413completing
complexing2444743complexing
complin13312073comp_lin_
compline14313553comp_line
complins14313103comp_lins
composting17178043composting
comprise14310813comp_rise
comprising1748633comprising
comprize2368733comp_rize
comprizing2647463comprizing
concaving1737353concaving
congaing1239823conga_ing
conjuring1937913conjuring
conspiring1546553conspiring
cooping123918933coop__ing
coopting133411313coop_ting
coparent12412253co_parent
coping113927663co_p__ing
coppicing1845403coppicing
copping143918593co_p_ping
copying153411983co_p_ying
coring94433963co___ring
cornering12311893cornering
corrading1338203corrading
coshering15510023coshering
costarring1345393costarring
coumarin1247323coumarin_
coumarins1347023coumarins
couping124317023coup__ing
coupling13310783coup_ling
couponing1446293couponing
covarying1844133co_varying
covering142215723co_vering
cowering142514033co_wering
cumarin1139263cum_arin_
cumarins1238643cum_arins
cumbering16108203cumbering
dogearing1235763dogearing
empaling1338363_empaling
hampering1738863hampering
homaging1536613hom_aging
homering141512073hom_ering
impairing1445473_impairing
impaling1338253_impaling
imparking1834713_imparking
imparting1437243_imparting
loppering14237283loppering
mortaring1237943mortaring
nonpaying1545713nonpaying
oaring74225303_o__aring
pampering1638383pampering
paring94236493___paring
pomading1437423pom_ading
preparing14311643preparing
rampaging1544513rampaging
ramparting1543883ramparting
roaring82916003ro__aring
romping123113033romp__ing
scampering1745323scampering
schmearing1842863schmearing
simpering1449293simpering
smearing113511753_smearing
soaring83521893so__aring
sparing104823873__sparing
tampering1438453tampering
tempering1438733tempering
umpiring1336093_umpiring
unsparing1237713unsparing
womaning1437643wom_aning

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.1731032896.0
2DLD Change Limit1486411547.73319221.6
3Display Results1541540.0801925.0
 (SQL Overall)1786911547.98622375.5
 
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.