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 “coins” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

332 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
coins7583455(None) 
cains75334301cains
chins105631461chins
cions75222851cions
coifs105718701coifs
coigns94410061coigns
coils75030081coils
coin66645351coin_
coirs75221051coirs
colins85229041colins
conins84327231conins
conns75024231conns
cons66057691co_ns
coons76737281coons
corns76034761corns
covins114618061covins
foins85523381foins
joins125818411joins
loins56728421loins
acorns85013012acorns
actins86321102actins
ains46158882_ains
aloins65022202aloins
amins75534322amins
ayins85321612ayins
bins66548252_bins
boils75427192boils
boing84725552boing
boings96416872boings
boink115516332boink
boinks125211272boinks
boons75031912boons
brins75533972brins
cabins104418922cabins
caids85226422caids
cain65643912cain_
cairns85313302cairns
cans65050852c_ans
carns75937562carns
ceils75019402ceils
chains114819702chains
chias104625522chias
chics123920942chics
chin96934742chin_
china105022482china
chinas115119402chinas
chine105231722chine
chines115029172chines
chink145321592chink
chinks155817572chinks
chino105823312chino
chinos115018692chinos
chints115117832chints
chips125721252chips
chis95933312chi_s
chits105424572chits
choirs114911882choirs
chopins142312242chopins
cigs75625102c_igs
cine66242942c_ine
cines75239682c_ines
cion613330912cion_
cis57748032c_i_s
clans75031012clans
cline76428532cline
clines84926042clines
cling86424672cling
clings95716212clings
clink115320042clink
clinks125815062clinks
clips96018302clips
clons75228132clons
clowns114810112clowns
coals76129602coals
coats75635002coats
cobbs115013992cobbs
cobias104014992cobias
cobs87043142co_bs
cocains111313922cocains
cocas95926572cocas
cochins141413102cochins
cocks135227162cocks
cocos95624692cocos
codas84724242codas
codeins103715482codeins
codens94821012codens
codes86247292codes
coding104024792coding
codlins104116242codlins
codons96119462codons
cods76848102co_ds
coeds85920162coeds
coffins153110192coffins
coffs134916302coffs
cogons96818112cogons
cogs77340032co_gs
cohos105921852cohos
coif96337912coi_f
coign85013912coign
coigne94612192coigne
coignes103912152coignes
coil66439652coi_l
coined94523602coined
coiner84323782coiner
coiners93620752coiners
coir66327242coi_r
coitus8511892coitus
cojoins1638992cojoins
cokes115537192cokes
coking134523882coking
colas75436772colas
colds85726972colds
coles76055062coles
colics104219902colics
colies84837052colies
colin76231692colin_
collins93419832collins
colons86028682colons
cols66553082co_ls
colts76633292colts
comas95833002comas
combs116122962combs
comes97246992comes
comics124015562comics
coming114225452coming
comings124013532comings
comps115526052comps
con510268022co_n_
cone67256962co_ne
cones76457422cones
coni65534802co_ni
conic95329792conic
conics103920592conics
conies84338592conies
conin76232722conin
conine84528552conine
conines93827792conines
coning94331822coning
conk106531442co_nk
conks115525702conks
conn66229132co_nn
conus76726532conus
cony96537832co_ny
coofs105924712coofs
cooing94024922cooing
cooks115429142cooks
cools75632632cools
coon67248942coon_
coops96229642coops
coos67456492co_os
coots75636842coots
copens106119962copens
copes97747102copes
copies104130302copies
coping113927662coping
copings124111842copings
cops86751372co_ps
cords86030622cords
cores76361852cores
coring94433962coring
corks116028272corks
corms95626222corms
corn69945812corn_
cornu75921322cornu
cornus84816562cornus
corny106023272corny
corps95927042corps
cors66656442co_rs
cortins92421332cortins
cos510270392co__s
coses76949492coses
cosies84932152cosies
cosigns1047512cosigns
cosine83823512cosine
cosines94122672cosines
coss66143492co_ss
costs77231142costs
cotans81317922cotans
cotes76347842cotes
coting94629252coting
cots68054842co_ts
count74932052count
counts84618272counts
coups95522472coups
cousins9516002cousins
covens114919262covens
coves105539172coves
covin105621122covin_
coving124321522coving
covings134511242covings
cowing124526322cowing
cowls106922212cowls
cows97046642co_ws
coxes145430862coxes
coxing164218862coxing
coying124021482coying
coys97537242co_ys
cozens176314922cozens
cozes166033242cozes
cozies174521412cozies
cribs94516752cribs
cries75438402cries
cris66233432cri_s
crits75527572crits
croons85418422croons
crowns115615112crowns
cuifs104814692cuifs
cuing85420192cuing
cumins103314932cumins
curns74924282curns
cutins83919982cutins
cyans105714812cyans
dins56652042_dins
djins1368452djins
doing74923582doing
doings84913182doings
doits66223672doits
dons56048702do_ns
downs94918572downs
eloins65419382eloins
eons46638712eo_ns
eosins64419162eosins
fins75849092_fins
fohns117310782fohns
foils85025812foils
foin77231562foin_
fons76943892fo_ns
gains65729512gains
gins55543952_gins
going75218492going
goings84911522goings
goons65326772goons
gowns95115102gowns
grins65427222grins
groins73917202groins
hins76447992_hins
hons77350782ho_ns
horns86125332horns
icons76516492ico_ns
ins35945602__ins
iodins74216522iodins
ions46737852io_ns
jins115635012_jins
johns15398712johns
join116724832join_
joint125227722joint
joints133811452joints
kains96125642kains
kins85747912_kins
koans95818622koans
koine9516482koine
koines10415732koines
kois85129402koi_s
lins47059052_lins
lions55923212lions
loans56026462loans
logins77820642logins
loids66220702loids
loin46838722loin_
loons55731722loons
mains75635112mains
moans74624372moans
moils76125752moils
mons68152262mo_ns
moons75331002moons
morns75527442morns
noils55024332noils
noirs55615462noirs
noons54125282noons
nouns56717312nouns
oils46337972_oils
oink85429342_oink
oinks94819912_oinks
ons36148512_o_ns
owns76819582_owns
pains75138282pains
peins76128062peins
pins65558452_pins
pions75826392pions
poind84217912poind
poinds93511142poinds
point75338732point
points85618532points
pois66539042poi_s
pons65850602po_ns
poons75430972poons
porns75527342porns
pyins105815862pyins
quins144819852quins
quoins154110582quoins
rains55140232rains
recoins94019242recoins
reins56234562reins
rins46153192_rins
roans54926442roans
robins83617452robins
roils54826792roils
rosins64521862rosins
ruins55822032ruins
sains55639972sains
scions82612242scions
scorns85713022scorns
shins85131042shins
sins46755272_sins
skins94723462skins
soils55327982soils
sons46049552so_ns
sorns55028422sorns
sozins15510792sozins
spins75327982spins
tains54936322tains
thins85826332thins
tins45251302_tins
toils54527492toils
toits55327472toits
tons46553052to_ns
toons55027532toons
towns86018882towns
toxins133314282toxins
twins85118982twins
veins84620492veins
voids95414672voids
wains86930872wains
whins114922332whins
wins75949172_wins
wons74942042wo_ns
yins75335122_yins
yogins105114102yogins
yonis85020822yonis
zeins144715392zeins
zins135735002_zins
zoons144919692zoons

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538003321.47036598.6
3Display Results3323320.0933569.9
 (SQL Overall)1786913321.85996122.1
 
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.