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

241 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
coiffing175593(None) 
coffing163811251co_ffing
coifing133213891coi_fing
biffing163510012_biffing
boffing16339982bo_ffing
chaffing2036322chaffing
cheffing2034462cheffing
chuffing2055042chuffing
codifying1944952codifying
coffin14339812co_ffin_
coffins153110192co_ffins
coffling1736482coffling
coiffuring1942572coiffuring
coigning1237172coigning
coiling103723452coi_ling
coining103920542coi_ning
cuffing163210252c_uffing
doffing15357792do_ffing
miffing16298402_miffing
offing13368642_o_ffing
riffing144011272_riffing
scoffing17275942sco_ffing
sniffing15227452sniffing
spiffing17237082spiffing
stiffing15248702stiffing
tiffing14339382_tiffing
whiffing2134702whiffing
baffing164011603_baffing
biffin14369103_biffin_
biffins15358533_biffins
bluffing17275493bluffing
boffin14359053bo_ffin_
boffins15329073bo_ffins
boiling103819673boi_ling
boinking15378423boinking
briefing1436943briefing
buffing163411393_buffing
ceiling103416723cei_ling
chafing163911493c_hafing
chefing16359033c_hefing
chiding143911593chi_ding
chiffon1844053chiffon_
chiffons1943693chiffons
childing15288503childing
chilling143512183chilling
chiming153311833chi_ming
chining133316843chi_ning
chinking183210893chinking
chinning14329653chinning
chipping18389793chipping
chirking18339383chirking
chirming16318643chirming
chirping16278863chirping
chirring142610173chirring
chitling142910663chitling
chivying2034973chivying
choiring14279793choi_ring
citifying1845383citifying
citing94220183c_i_ting
clefting14347583clefting
clicking173610983clicking
cliffier1633913cliffier
climbing15205983climbing
clinging122910913clinging
clinking153611663clinking
clipping15349153clipping
cliquing2035363cliquing
coaching164011963coaching
coacting133412703coacting
coalifying1945033coalifying
coaling103722823co_aling
coaming123818323co_aming
coapting133511613coapting
coasting113615513coasting
coating103525313co_ating
coaxing173511703co_axing
cobbling15248803cobbling
cocking163619983co_cking
cockling172310393cockling
codding124014693co_dding
coddling13258473coddling
coding104024793co__ding
codling114418953co_dling
coercing1349003coercing
coffering1838043coffering
coffined1735993co_ffined
coffining1845483coffining
cogging123513713co_gging
cohering142413833cohering
coiffe1447043coiff__e
coiffed1635413coiff_ed
coiffes1546803coiff_es
coiffeur1642153coiffeur
coiffure1643123coiffure
coking134523883co__king
collying14319543collying
coloring11414843coloring
comaking1739993comaking
combing143714733co_mbing
coming114225453co__ming
comping143518593co_mping
compting153013603compting
confiding1638333confiding
confine12315583co_nfine
confining1539993confining
confusing1537333confusing
confuting1539093confuting
congaing1239823congaing
coning94331823co__ning
conking143618453co_nking
conning103718753co_nning
cooeeing1137453cooeeing
cooeying1438143cooeying
cooing94024923co__oing
cooking143818973co_oking
cooling103422573co_oling
cooping123918933co_oping
coopting133411313coopting
coping113927663co__ping
copping143918593co_pping
copying153411983co_pying
cording113620823co_rding
coring94433963co__ring
corking143018823co_rking
cornifying1944813cornifying
corning103720123co_rning
coshing134316433co_shing
cosigning1345393cosigning
costing104323023co_sting
cosying134513133co_sying
coting94629253co__ting
couching163213263couching
coughing15309213coughing
counting113115273counting
couping124317023co_uping
coupling13310783coupling
coursing113112023coursing
courting112514573courting
covering142215723covering
coveting141912303coveting
coving124321523co__ving
cowering142514033cowering
cowing124526323co__wing
cowling134017423co_wling
coxing164218863co__xing
coying124021483co__ying
cozening20188303cozening
cozying22308063co_zying
crafting143710173crafting
cribbing15276843cribbing
cricking173412653cricking
crimping15299783crimping
cringing123311383cringing
crisping13319663crisping
daffing15369733_daffing
deifying1637633deifying
drifting13338733drifting
edifying1636083edifying
feoffing1432963feoffing
fifing134212343_fi_fing
fluffing14275413fluffing
foiling113317653foi_ling
foining113013453foi_ning
foisting122910503foisting
gaffing15379733_gaffing
gifting123810893_gifting
golfing12368943go_lfing
goofing123510633go_ofing
griffin1434513griffin_
griffins1544783griffins
grifting13299263grifting
gruffing1635273gruffing
hoicking1836053hoicking
hoising113414413hoi_sing
hoisting123610903hoisting
hoofing143912553ho_ofing
huffing17278833_huffing
joining153011483joi_ning
jointing16248613jointing
joisting16328503joisting
knifing1536483kni_fing
lifting113313273_lifting
loafing11319793lo_afing
lofting113311313lo_fting
loiding93313403loi_ding
luffing143310103_luffing
modifying1944663modifying
moiling103417663moi_ling
muffing163210403_muffing
naffing14359033_naffing
noising83615173noi_sing
notifying1645623notifying
offings14285833_o_ffings
oiling74925313_oi_ling
oinking123714713_oinking
piaffing1733923piaffing
piffling1745133_piffling
poinding122510003poinding
pointing112813683pointing
poising103617103poi_sing
puffing162910943_puffing
quaffing2434353quaffing
reffing143712173_reffing
reifying1539383reifying
riffling1556113_riffling
rifling112815013_rifling
rifting113515003_rifting
roiling83220453roi_ling
rolfing113710653ro_lfing
roofing113814353ro_ofing
ruffing143210843_ruffing
sclaffing1843363sclaffing
scorifying1944473scorifying
scuffing17287113scuffing
shifting152910383shifting
sifting113014593_sifting
skiffling2043103skiffling
sluffing15247303sluffing
sniffling1644093sniffling
snuffing15256803snuffing
soiling83422323soi_ling
spiffying2142753spiffying
staffing15247493staffing
stifling122110913stifling
stuffing15247843stuffing
tariffing1644113tariffing
tiffin12327933_tiffin_
tiffins13327983_tiffins
toiling83219023toi_ling
toiting83217093toi_ting
trifling122411503trifling
unifying1537553unifying
voicing13279083voi_cing
voiding122910363voi_ding
waffing173710243_waffing
waifing142910893wai_fing
whiffling2242883whiffling
wifing133513393_wi_fing
wolfing14277893wo_lfing
woofing14349893wo_ofing
yaffing17337823_yaffing

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622416.75021653.6
3Display Results2412410.0932591.4
 (SQL Overall)1786912417.24924650.4
 
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.