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

301 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
comfit13311242(None) 
comfits14328741comfits
commit124016701commit
confit113316401confit
coedit9316242coedit
coffin14339812coffin
coft97939682co_f_t
combat12316752combat
comet95946072com_et
comfier1439162comfier
comfiest1539132comfiest
comfort143611692comfort
comfy153710212comf_y
comic114721812com_ic
comity13312712com_ity
comix163513202com_ix
commie124215522commie
commits133812382commits
commix19407762commix
commixt20357622commixt
compt116328222com_pt
confits122811422confits
omit65337372_om_it
soffit1237882soffit
tomtit8413852tomtit
vomit102622572vom_it
admit8319493adm_it
ambit94223713_ambit
armpit10811093armpit
befit105222663_befit
boffin14359053boffin
bowfin14338353bowfin
camail10314833camail
cambia124913153cambia
cambist13312113cambist
camlet104426583camlet
cammie124615293cammie
campi116217783campi_
cement103321673cement
chit96937463c__hit
cleft106222853clef_t
clift106422193clif_t
coact96130583co_act
coadmit1247833coadmit
coalpit1148513coalpit
coapt96131533co_apt
coast75236273co_ast
coat67558353co__at
coati75624643coati_
coatis85122603coatis
cobalt10317393cobalt
cobia94117513co_bia
cobnut10311323cobnut
cocain101315013cocain
cocci82812673cocci_
coccic8298943coccic
coccid102910743coccid
cochin131313203cochin
cockpit1747993cockpit
codeia94112193codeia
codein94916723codein
codfish1637163codfish
codify1537163codify
codlin94516443codlin
coedits10310243coedits
coempt12311033coempt
coesite9713623coesite
coexist1638583coexist
coff126930783co_f_f
coffee144113743coffee
coffer144112863coffer
coffing163811253coffing
coffins153110193coffins
coffle14359043coffle
coffret15310073coffret
coffs134916303co_ffs
cogent9321003cogent
cogito939203co_gito
cohabit1449563cohabit
coheir1137583coheir
cohort1110720263cohort
cohost115217213cohost
coif96337913co__if
coifed124113063coifed
coiffe1447043coiffe
coifing133213893coifing
coifs105718703coif_s
coil66439653co__il
coin66645353co__in
coir66327243co__ir
cojoin1539503cojoin
colic95726173co_lic
colin76231693co_lin
collet84030363collet
collie83621993collie
colt67158243co__lt
coma87134853com__a
comade114415323comade
comae97128423com_ae
comake144413423comake
comal95125133com_al
comas95833003com_as
comate104124843comate
comatic131816943comatic
comatik15139723comatik
comb106632113com__b
combats13311683combats
combe116223543com_be
combed135516543combed
comber125118503comber
combes125321733combes
combine133014723combine
combing143714733combing
combo114519433com_bo
combos125316613combos
combs116122963com_bs
combust1338363combust
come87547703com__e
comedic14158633comedic
comedo11359603comedo
comedy14378233comedy
comely134213733comely
comer95832693com_er
comers105328083comers
comes97246993com_es
cometh134811683cometh
cometic131215723cometic
comets105823583comets
comforts15347323comforts
comfrey1734683comfrey
comics124015563comics
coming114225453coming
comitia1139723comitia
comma114514793com_ma
commas124814573commas
commata1338483commata
comment1310317703comment
commies133718453commies
common12310803common
commute134310443commute
commy144712643com_my
comose105016853comose
comous10816513comous
comp106731253com__p
compact153712213compact
compart134016003compart
compas125817063compas
comped135919873comped
compel124412893compel
compete134716553compete
compile13312443compile
comping143518593comping
complin13312073complin
complot13310683complot
comply152810383comply
compo115318573com_po
comport133616843comport
compos124818803compos
compost134515353compost
compote135616463compote
comps115526053com_ps
compts125216653compts
compute134513663compute
comte96125473com_te
comtes106222813comtes
conceit113218073conceit
conduit10713083conduit
confab1347063confab
confect143614273confect
confer114018683confer
confide13310203confide
confine12315583confine
confirm1437363confirm
conflict1547753conflict
confute1239263confute
congii957363congii
coni65534803co_ni_
conic95329793co_nic
conin76232723co_nin
conoid9818883conoid
consist9316033consist
convict143410983convict
coof96643273coof__
coofs105924713coof_s
cookie123716043cookie
coolie83821603coolie
coopt95929853co_opt
coot67860383co__ot
cootie84223093cootie
coplot10518273coplot
copout10418783copout
copyist1439053copyist
coquet174318013coquet
coquito1845403coquito
corbie103618203corbie
cordite10315263cordite
corf95941483corf__
corgi8316083corgi_
corgis9314413corgis
coria75828323co_ria
cormoid12310403cormoid
cornet84436733cornet
corrie83621233corrie
corset85636223corset
cortin82423153cortin
corvet114626933corvet
corvid12310473corvid
coset75748843co_set
cosie74728273co_sie
cosmic12410343cosmic
cosmid11810643cosmid
cosmist11311333cosmist
cosset84125863cosset
cost68057943co__st
cot510483223co___t
coulis84018763coulis
count74932053co_unt
court75532773co_urt
cousin8517163cousin
covert114925503covert
covet105638943co_vet
covin105621123co_vin
cowfish1836433cowfish
cowpat13312033cowpat
cowpie133511513cowpie
cowrie113814283cowrie
cowrite123612683cowrite
coyest11316053coyest
cozie163519133co_zie
craft105327663craf_t
crampit1338863crampit
credit9315193credit
crit65743713c__rit
croft105622683crof_t
cubit94122893c_ubit
cumbia12379893cumbia
cumin94616973cum_in
cummin1288783cummin
cymlin1337313cymlin
cymoid1459473cymoid
dammit11311133dammit
demit84832303dem_it
dimwit1237953dimwit
discomfit1754683discomfit
doit56347853do__it
domain9511323domain
domic104317243dom_ic
emit65438423_em_it
fit66365463___fit
foment113718303foment
fomite113314073fom_ite
forfeit1339203forfeit
forrit91916623forrit
gambit114714213gambit
godwit1137513godwit
gomuti936553gomuti
haffit1538533haffit
hobbit132810543hobbit
homie104622533hom_ie
limit73126343lim_it
loft76539143lo_f_t
lomein8410203lomein
loment84021473loment
misfit112813833misfit
moment103319683moment
momi87524483mom_i_
nomoi76012533nomoi_
nonfat9512183nonfat
obit66837083_o_bit
oft67744063_o_f_t
omits75018263_om_its
orbit73622063_orbit
outfit93014953outfit
pomfret1446993pomfret
pommie123710503pommie
posit75833333po_sit
profit113016273profit
recommit1445553recommit
refit84230063_refit
remit75737223rem_it
roofie93411173roofie
semifit1249973semifit
smit65138413_sm_it
sobeit8315363sobeit
soffits1335093soffits
soft76942823so_f_t
somite84519373som_ite
summit10311543summit
toft77441653to_f_t
toit46353063to__it
tomcat101013453tomcat
tomtits937243tomtits
unfit84518563_unfit
vomito11238033vom_ito
vomits112610923vom_its
wombat1339863wombat
worrit92313313worrit
yomim12510083yom_im
zombi1838993zombi_
zombie1937323zombie
zombis1936283zombis

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127163014.87323130.7
3Display Results3013010.1102736.4
 (SQL Overall)1786913015.35933344.1
 
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.