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

132 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
confusing153733(None) 
confuting1539091confuting
contusing1239141contusing
censusing1244812censusing
cohousing1535282cohousing
concussing1546142concussing
conducing1537692conducing
confessing1647182confessing
confiding1638332confiding
confining1539992confining
confusingly2052702confusingly
confusion1446472confusion
confusions1546302confusions
conjuring1937912conjuring
consuming1437912consuming
convulsing1645382convulsing
infusing1237902_infusing
nonusing939232non_using
unconfusing1752262unconfusing
bousing103718043bo__using
callusing1236173callusing
campusing1654913campusing
canvasing1546433canvasing
carousing1237893carousing
caucusing1443803caucusing
causing103614413c__ausing
censing104215263cen__sing
censuring1237603censuring
chorusing15246113chorusing
chousing14259423c_housing
coenduring1444233coenduring
coffering1838043coffering
coffing163811253co_f_fing
coffining1845483coffining
coffling1736483co_ffling
cognising1347043cognising
cohousings1642123cohousings
coiffing1755933coif_fing
coiffuring1942573coiffuring
coifing133213893coif__ing
coinsuring1345373coinsuring
colluding1335903colluding
colouring1258733colouring
combusting1745453combusting
communing16207863communing
commuting16288443commuting
composing16179843composing
computing16309853computing
concaving1737353concaving
conceding1559343conceding
concluding1644913concluding
concubine1545753concubine
concurring1546603concurring
condensing1447743condensing
condoling13510373condoling
condoning1339783condoning
conducting1648833conducting
confabbing2042503confabbing
confecting18310553confecting
conferring1648743conferring
configuring1853153configuring
confine12315583conf__ine
confirming1845903confirming
conflating16410003conflating
conforming1847373conforming
confounding1843263confounding
confuse1238853confus__e
confused1437033confus_ed
confuses13310363confus_es
confusional1654243confusional
congaing1239823con_gaing
congeeing1337903congeeing
congesting14410113congesting
coning94331833con___ing
conking143618453con__king
conning103718763con__ning
conniving1537093conniving
connoting12310023connoting
conquering2246273conquering
consign1038773con__sign
consisting1349523consisting
consoling12310873consoling
consulting1349083consulting
contesting13312213contesting
contouring1347013contouring
contusion1147063contusion
contusions1246993contusions
contusive1445783contusive
convening15311203convening
conversing16310543conversing
conveying1838323conveying
convoking1935743convoking
convoying1835983convoying
cornhusking2171393cornhusking
costuming1445283costuming
couping124317023co__uping
coursing113112023co_ursing
cousin8517163co__usin_
cousins9516003co__usins
defusing13227943_defusing
diffusing1743863diffusing
dousing93315763do__using
effusing1534273_effusing
focusing1436603fo_cusing
fondueing1443093fondueing
fonduing13245893fondu_ing
fusing104415953___fusing
hocusing1446583ho_cusing
honouring1336883honouring
housing113316523ho__using
incusing1159953_incusing
ionising9310223ion_ising
jonesing1636633jon_esing
lousing83817733lo__using
mousing103816273mo__using
nonbuying1543953nonbuying
nonfading1445873nonfading
nonflying1643673nonflying
nonhousing1444513nonhousing
nonjuring1756053nonjuring
nonplusing1344593nonplusing
nonruling1046433nonruling
onrushing1364813_onrushing
perfusing1565633perfusing
refusing122310873_refusing
reinfusing1443613reinfusing
rousing83920553ro__using
sousing83517823so__using
suffusing1643543suffusing
tonguing1046263tongu_ing
tonsuring1046503tonsuring
tousing82916993to__using

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.500357382.0
2DLD Change Limit1486411327.61019532.3
3Display Results1321320.0632095.2
 (SQL Overall)1786911328.17321863.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.