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

128 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
comfinesses184691(None) 
campinesses1737112campinesses
cockinesses1947562cockinesses
comelinesses1666402comelinesses
comfiness1646952comfine_s_s
corkinesses1749212corkinesses
corninesses13410592corninesses
cosinesses121012822co_sinesses
cozinesses21179502co_zinesses
goofinesses1535962goofinesses
hominesses15510862hom_inesses
beefinesses1675953beefinesses
bogginesses1555673bogginesses
boninesses121111453bo_ninesses
bonninesses1337353bonninesses
boozinesses22175803boozinesses
boskinesses17136813boskinesses
bossinesses12117353bossinesses
boxinesses19127903bo_xinesses
bumpinesses17126373bumpinesses
caginesses13310943c_aginesses
cakinesses16310613c_akinesses
canninesses1368853canninesses
cattinesses13129703cattinesses
charinesses1639563charinesses
chewinesses1945143chewinesses
choppinesses2143353choppinesses
chumminesses2142863chumminesses
clamminesses1873793clamminesses
cloudinesses1545123cloudinesses
clumsinesses1644773clumsinesses
coheiresses1643413coheiresses
coldnesses1338423co_ldnesses
commonnesses18103183commonnesses
compresses1647773com_presses
confesses1438623conf__esses
coolnesses1237193co_olnesses
costlinesses1446253costlinesses
coynesses1437573co__ynesses
craftinesses1746383craftinesses
crazinesses2237933crazinesses
crumminesses1843653crumminesses
curlinesses1338733curlinesses
cushinesses16127413cushinesses
daffinesses1834843daffinesses
dodginesses1435433dodginesses
dopinesses13159723do_pinesses
dorkinesses1647663dorkinesses
dottinesses1238133dottinesses
dowdinesses1635723dowdinesses
downinesses1536143downinesses
dozinesses20168633do_zinesses
dumpinesses16126253dumpinesses
finesses111912343___finesses
foaminesses1658073foaminesses
fogginesses1645493fogginesses
forkinesses1848003forkinesses
foxinesses20127733fo_xinesses
fozinesses22158193fo_zinesses
gaminesses13410463gam_inesses
gemminesses1634983gemminesses
godlinesses1337123godlinesses
gorinesses11311553go_rinesses
goutinesses1239973goutinesses
gumminesses1634933gumminesses
hamminesses1835773hamminesses
hoarinesses14310223hoarinesses
hokinesses1758943ho_kinesses
holinesses13511493ho_linesses
homelinesses1765363homelinesses
homeynesses1984813homeynesses
horninesses1459003horninesses
horsinesses1439553horsinesses
huffinesses2034123huffinesses
humpinesses18106243humpinesses
iffinesses1635583_iffinesses
jokinesses2147533jo_kinesses
jollinesses1836723jollinesses
jowlinesses2135323jowlinesses
jumpinesses22125343jumpinesses
kookinesses1435373kookinesses
leafinesses1437873leafinesses
liminesses121310853lim_inesses
loaminesses1358453loaminesses
loftinesses1437923loftinesses
loginesses11410323lo_ginesses
looninesses1197993looninesses
loopinesses13116733loopinesses
lousinesses111210323lousinesses
lowlinesses1436683lowlinesses
lumpinesses15107113lumpinesses
miffinesses1944363miffinesses
moldinesses14138043moldinesses
moodinesses14147643moodinesses
mooninesses13127943mooninesses
mopinesses14139123mo_pinesses
mossinesses12117463mossinesses
mousinesses13129833mousinesses
noisinesses1139483noisinesses
nosinesses101411323no_sinesses
oilinesses101512443_oilinesses
oozinesses19178023_oozinesses
pokinesses1669613po_kinesses
porkinesses1748773porkinesses
pottinesses1339103pottinesses
puffinesses1934513puffinesses
riminesses121211413rim_inesses
rockinesses1737363rockinesses
roominesses1337433roominesses
rootinesses1139523rootinesses
ropinesses121311023ro_pinesses
rosinesses101213143ro_sinesses
rowdinesses1536963rowdinesses
smokinesses1736253smokinesses
soapinesses1339713soapinesses
softnesses1337603so_ftnesses
sogginesses1346773sogginesses
sootinesses11410053sootinesses
soppinesses1566843soppinesses
sorrinesses11310093sorrinesses
wimpinesses1835633wimpinesses
womannesses1644393womannesses
woodinesses15127463woodinesses
woolinesses14157503woolinesses
woozinesses23175633woozinesses
wordinesses15138883wordinesses
worminesses16127993worminesses
yumminesses1843873yumminesses

Search took 5 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 Filter1786911216330.390458182.1
2DLD Change Limit1216331284.51626933.8
3Display Results1281280.0801600.0
 (SQL Overall)1786911284.98635838.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.