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

248 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
confab134706(None) 
confabs1435391confabs
confer114018682confer
confit113316402confit
conga85419872conga_
congas94417032congas
nonfan948292nonfan
nonfat9512182nonfat
bonsai838463bonsai
cab78355403c___ab
canal75428043can_al
cancan10314103cancan
canful11610263canful
canna75919333canna_
cannas84518403cannas
cantal84122033cantal
canvas113813333canvas
centai84814783centai
cental84420963cental
centas85020703centas
chufa13489113chufa_
chufas14397673chufas
clonal8310913clon_al
coal66939253co__al
coala77521123coala_
coalas87418963coalas
coat67558353co__at
coax136922983co__ax
coaxal15387303coaxal
cob710258753co___b
cobb106422003co__bb
cobia94117513cobia_
cobias104014993cobias
cobra95214403cobra_
cobras104014193cobras
cobweb1533243cobweb
coca88030643co_ca_
cocas95926573co_cas
coccal9310223coccal
cocoa98517883cocoa_
cocoas104915743cocoas
coda77029343co_da_
codas84724243co_das
coeval1138893coeval
coff126930783co_f_f
coffee144113743coffee
coffer144112863coffer
coffin14339813coffin
coffle14359043coffle
coffs134916303co_ffs
coft97939683co_f_t
cognac1157273cognac
cogway1566183cogway
cohead123811123cohead
coif96337913coif__
coifed124113063coifed
coiffe1447043coiffe
coifs105718703coif_s
coinfer12419393coinfer
coital84117053coital
cola66541393co_la_
colas75436773co_las
colead94114643colead
collar83816173collar
colza165112983colza_
colzas174010513colzas
coma87134853co_ma_
comae97128423co_mae
comal95125133co_mal
comas95833003co_mas
comb106632113co__mb
combat12316753combat
comfit133112423comfit
comfy153710213comf_y
comma114514793comma_
commas124814573commas
compas125817063compas
con510268023con___
concave1439373concave
conceal113313013conceal
conch124620073con_ch
concha134213283concha
conchae143911643conchae
conchal144211583conchal
conchas144013313conchas
concho134414263concho
conchs134714903conchs
conchy163710223conchy
concur10411103concur
condo85322593con_do
condom114215363condom
condor94616973condor
condos94322333condos
cone67256963con__e
coned86040053con_ed
cones76457423con_es
coney105932883con_ey
coneys115218423coneys
confabbed1942463confabbed
confect143614273confect
confers124120093confers
confess12399903confess
confide13310203confide
confine12315583confine
confirm1437363confirm
confits122811423confits
conflate13311173conflate
conflux1943003conflux
confocal1546303confocal
conform14310463conform
confuse1238853confuse
confute1239263confute
congaed11399743congaed
conge85227593con_ge
congeal104011683congeal
congee96024473congee
conger95024273conger
conges94928173conges
congii957363congii
congo85623133con_go
congos94219883congos
congou94313243congou
coni65534803con__i
conic95329793con_ic
conical11316203conical
conics103920593conics
conies84338593conies
conifer123212643conifer
conin76232723con_in
conine84528553conine
coning94331823coning
conins84327233conins
conium10415313conium
conk106531443con__k
conked135019113conked
conker124721553conker
conks115525703con_ks
conky145818743con_ky
conn66229133con__n
connate9315753connate
conned95119703conned
conner84423963conner
conns75024233con_ns
conoid9818883conoid
cons66057693con__s
consol82614113consol
consul82312303consul
contact1144020683contact
contain9315833contain
conte76633203con_te
contes84432913contes
conto76027173con_to
contos84923233contos
contra83314703contra
contras93015623contras
conus76726533con_us
convex18367743convex
convey144610223convey
convoy14348543convoy
cony96537833con__y
coof96643273coof__
coofs105924713coof_s
coomb115615703co_omb
cooncan1147233cooncan
copal95621783co_pal
copay126516313co_pay
copra98115463copra_
coprah133710603coprah
copras103517153copras
coral76033453co_ral
corban10314693corban
corf95941483corf__
coria75828323coria_
corncob1345663corncob
cornea84018923cornea_
corneal94414503corneal
corneas94717003corneas
cornfed1337383cornfed
cornua85411903cornua_
cornual94210173cornual
corral83616253corral
corsac10410173corsac
corymb1535223corymb
costa75523733costa_
costae85319683costae
costal85419513costal
costar85518613costar
cotan71521783co_tan
coteau8311083coteau
cotta75818573cotta_
cottae84615703cottae
cottar84613813cottar
cottas84615573cottas
cougar958783cougar
cowflap1742503cowflap
cowman13910373cowman
cowpat13312033cowpat
coxa136922963co_xa_
coxae146115183co_xae
coxal146116673co_xal
crab85727673c__rab
cuneal8611513cuneal
dona55529633don_a_
donas65926473don_as
donga76718423donga_
dongas84914613dongas
donna66215033donna_
donnas75511323donnas
eonian6311833eonian
fab87453133___fab
fontal9313143fontal
gonad75216053gon_ad
gonia64117533gonia_
honan85319773hon_an
honda9414983honda_
hondas10313353hondas
longan75612363longan
loofa85912813loofa_
loofah12375813loofah
loofas9429833loofas
monad85519473mon_ad
monas74732153mon_as
nab56954923__n_ab
nona46929063non_a_
nonas55126653non_as
nonfact1248893nonfact
nonfans1037533nonfans
nonfarm1246513nonfarm
nongay10169153nongay
nonman8412363nonman
nonpar8168993nonpar
nontax1348413nontax
nonwar9159423nonwar
ofay106416103_o_fay
offal1136243_offal
onlay84212943_onlay
prefab1336243prefab
sofa75625603so_fa_
sofar86115493so_far
sofas85320713so_fas
sonar56523423son_ar
tonal53724303ton_al
tonga65619693tonga_
tongas74315523tongas
vocab12409973vo_cab
zona136321963zon_a_
zonae145116443zon_ae
zonal145116853zon_al

Search took 7 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.373479064.3
2DLD Change Limit1127162485.86019234.8
3Display Results2482480.0803100.0
 (SQL Overall)1786912486.31328305.2
 
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.