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

142 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
composing1617984(None) 
composting17178051composting
campusing1654912campusing
commoving1944982commoving
comparing162410582comparing
compassing1746552compassing
compering163414162compering
competing163712462competing
compiling1637762compiling
comping143518592comp__ing
complying1936112complying
comporting17199162comporting
composite15410152composite
compositing1846262compositing
comprising1748632comprising
compting153013602comp_ting
computing16309852computing
couponing1446292couponing
decomposing1943632decomposing
imposing1348462_imposing
opposing1336382_opposing
recomposing1844222recomposing
apposing1337403_apposing
cameoing1379063cameo_ing
campesino1544633campesino
camping143118973camp__ing
campong14318123campo__ng
chomping18339883chomp__ing
choosing142010133c_hoosing
clomping15329653clomp__ing
closing103114843c__losing
coapting133511613coap_ting
cocooning1447023cocooning
coemploying2152413coemploying
coempting1636073coemp_ting
cognising1347043cognising
cohosting1546323co_hosting
cohousing1535283cohousing
coloring11414843co_loring
comaking1739993com_aking
combating16310163combating
combing143714733com__bing
combining1637893combining
combusting1745453combusting
comforting18165933comforting
coming114225453com___ing
commixing2345193commixing
communing16207863communing
commuting16288443commuting
compacting19177093compacting
companying2044813companying
comparting17188383comparting
compeering1747053compeering
compelling1746553compelling
complain1448763complain_
complains1549193complains
complaint15410253complaint
completing1748423completing
complexing2444743complexing
complin13312073comp_lin_
compline14313553comp_line
complins14313113comp_lins
complotting18124263complotting
compone136517193compo__ne
component15411083component
compony1613011913compo__ny
compos124818803compos___
compose135716663compos__e
composed154612063compos_ed
composer145012953compos_er
composers153910623composers
composes145017113compos_es
composited1756003composited
composites1648903composites
compositor1644633compositor
compost134515353compos__t
composted16378813composted
composter15369563composter
composts144210913compos_ts
composure1545123composure
compound1555993compo_und
compounding1943073compounding
compressing1846433compressing
comprizing2647463comprizing
compromising2152923compromising
condoling13510373condoling
condoning1339783condoning
confusing1537333confusing
connoting12310023connoting
consoling12310873consoling
contusing1239143contusing
convoking1935743convoking
convoying1835983convoying
cooing94024923co__o_ing
cooking143818973co__oking
cooling103422573co__oling
coopering142611323coopering
cooping123918933co__oping
coopting133411313coop_ting
coping113927663co_p__ing
coppering162810893coppering
coppicing1845403coppicing
copping143918593co_p_ping
copying153411983co_p_ying
cordoning1338063cordoning
corposant1347093corposant
corroding1337943corroding
cottoning1237343cottoning
couping124317023coup__ing
coupling13310783coup_ling
couponings1542783couponings
coursing113112023co_ursing
cowboying2043183cowboying
deposing12129773_deposing
discomposing2052833discomposing
disposing1339933disposing
exposing1836673_exposing
goosing93314083go__osing
imponing1338773_imponing
imposting1436813_imposting
loosing83515963lo__osing
noosing83315053no__osing
oompahing1773173oompahing
osmosing1135223_osmosing
pomposity1844653pomposity
porpoising1545833porpoising
posing93922643___posing
postposing1555023postposing
proposing1439673proposing
purposing1445233purposing
reimposing1544463reimposing
reopposing1543653reopposing
reposing111213803_reposing
romping123113033romp__ing
roosing84018133ro__osing
schmoosing1843143schmoosing
supposing1445843supposing
tamponing1445993tamponing
unimposing1542903unimposing
vamoosing1543653vamoosing
vamosing1435593vam_osing
woopsing1435633woop_sing

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 Limit1486411426.55022693.3
3Display Results1421420.0602366.7
 (SQL Overall)1786911427.03025418.3
 
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.