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

231 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
dacoits107907(None) 
dacoit9415451dacoit_
dacoity1366181dacoity
dakoits1245291dakoits
dacite91115882dac_ite
dacites101114592dac_ites
dacoities1248212dacoities
dakoit11310352dakoit_
dakoity1543422dakoity
davits104012362da_vits
deceits102810882deceits
decocts1237832decocts
dicots94915792dico_ts
doits66223672d__oits
droits74314312d_roits
aborts84916183_aborts
accosts11107993accosts
acids87121003_ac_ids
aconite9315473_aconite
aconites10314353_aconites
acorns85013013_acorns
acquits1857293_acquits
actins86321103_actins
acts66929863_ac__ts
acuity1139373_acuity
adits66523713_a_dits
adjoins1585983adjoins
adjoints16103873adjoints
admits9411413_admits
adopts998083_adopts
adroit7518793adroit_
afrits9311903_afrits
aits46355533_a__its
aloins65022203_aloins
ambits103713413_ambits
anoints7311063_anoints
aroids75118223_aroids
aroints7313133_aroints
ascots85312513asco_ts
audits72814113_audits
avoids104410203_avoids
awaits96411953_awaits
backfits19106953backfits
backouts1698643backouts
bacons104917583baco_ns
baits76630583ba__its
bandits103814793bandits
bankits133410153bankits
cachets145014263cachets
cahoots1238473cahoots
cavorts1237933cavorts
chits105424573__chits
coats75635003__coats
coifs105718703__coifs
coils75030083__coils
coins75834553__coins
coirs75221053__coirs
coitus8511893__coitus
colts76633293__colts
coots75636843__coots
costs77231143__costs
cots68054843__co_ts
crits75527573__crits
daces85030683dac__es
dachas124113253dac_has
dackers143417043dackers
dacrons103211033dacrons
dactyls1333913dactyls
dadaist9310103dadaist
dadaists1045583dadaists
daddies103414943daddies
dadoes85616533dado_es
dadoing1038523dadoing
dados75522433dado__s
dagobas1145143dagobas
dagoes85714603dago_es
dagos76419443dago__s
dahlias1135723dahlias
dahoons1137753dahoons
dailies84219263dailies
daimios1035753daimios
dairies84217733dairies
dais57040703da__i_s
daisies84217093daisies
dakoities1444673dakoities
dallies84023193dallies
dammit11311133dammit_
dandies94121443dandies
danios7314603da_nios
darbies104216983darbies
darics94314113da_rics
darkies124015753darkies
darts67635733da__rts
dashis104414393dashi_s
dassies84418663dassies
datos65222783dato__s
daunts75014083da_unts
dauties83315763dauties
dauts67822243da__uts
davies105020513da_vies
davit93424593da_vit_
dawties113312703dawties
dawts97216123da__wts
daylit10512493daylit_
deacons10310393deaco_ns
debits94214503d_ebits
decants103514443decants
deceit93018213deceit_
decoct11313783decoct_
decodes113914983decodes
decors94017773deco_rs
decos85522123deco__s
decoys123911283deco_ys
decries103319813decries
dehorts11379773dehorts
demits94918073d_emits
deports105012883deports
deposits1138843deposits
depots94716343depo_ts
devoirs1175783devoirs
dhootis1135683dhootis
dhotis1038973d_hotis
diacids1137863diac_ids
dicasts1078703dicasts
dickies143416343dickies
dicot85429093dico_t_
digits84114533d_igits
dimouts1037893dimouts
dimwits1344513dimwits
discoids1239873discoids
dits56450523d___its
divots104712203divo_ts
dixits144210313d_ixits
doats65224883d__oats
docents102810803docents
dockets144412243dockets
doit56347853d__oit_
dolts65626313d__olts
dots55647663d__o_ts
droids84712583d_roids
droit65127123d_roit_
ducats95011763duc_ats
duchies133312313duchies
duckies143613813duckies
ducts85319893duc__ts
dugouts935043dugouts
duits65021883d__uits
edacious1146023edacious
edacity1336373edac_ity
escorts9418403escorts
escots84211743esco_ts
facets116316653fac_ets
facias113415803fac_ias
facies113921593fac_ies
factoids1446243factoids
facts107021893fac__ts
fagots1039963fago_ts
fucoids1335663fucoids
gadoids1036873gadoids
gaits65726013ga__its
galiots82311323galiots
galoots82410793galoots
gambits12399723gambits
ganoids939333ganoids
gavots1038113gavo_ts
habits113014653ha_bits
hackies163418243hackies
haffits1636193haffits
haloids113012553haloids
jabots1538883jabo_ts
jackets205011373jackets
jackies202912623jackies
jacobins1944193jacobins
jacobus1843173jacobus
jaconets1745613jaconets
kainits1137763kainits
layouts1046483layouts
macons104017243maco_ns
magots9312363mago_ts
mahouts1237143mahouts
mascots113910343masco_ts
mucoids1237423mucoids
packets155114773packets
pacts95125803pac__ts
pandits103914213pandits
patois84319363patoi_s
payouts1247303payouts
peacoats1247833peacoats
picots104616443pico_ts
placoids1347343placoids
quoits15379683_quoits
rabbits11299863rabbits
rachets124516833rachets
rachis114017653rachi_s
rachitis1348353rachitis
racist82822793rac_ist
racists92613323racists
rackets134916873rackets
racons84319343raco_ns
racoons93912433racoons
ragouts838543ragouts
recits83621353rec_its
recoats92616643recoats
recoils93814873recoils
recoins94019243recoins
sabots8314703sabo_ts
sacbuts1166473sacbuts
sachets123914103sachets
sacrist9315423sacrist
sacrists1039563sacrists
sarcoids1137803sarcoids
scoots85315943_scoots
scots74025913_sco_ts
scouts84817943_scouts
tachist12613293tachist
tachists1348183tachists
tacit76333673tac_it_
tackets134914363tackets
taconite1049313taconite
taconites1148473taconites
tacos77023553taco__s
tactics1149323tactics
tacts76524123tac__ts
tallits73215993tallits
tarots66422993taro_ts
toits55327473__toits
uncoils979533uncoils
upcoils1184933upcoils
vacuity1545763vacuity
waits88333523wa__its
yachts1437023yac_hts

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272316.75019855.9
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.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.