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

353 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
cain6564391(None) 
ain37579091_ain
cabin94820931cabin
caid77837531caid
cains75334301cains
cairn75717511cairn
can57760131ca_n
carn66245431carn
chain105723671chain
chin96934741chin
coin66645351coin
fain75840561fain
gain56042161gain
kain85334291kain
lain46146281lain
main65345501main
pain65647241pain
rain46251731rain
sain45551291sain
tain45548071tain
vain75233001vain
wain75840191wain
acid77533392acid
acing87429152acing
acini75718982acini
actin74922552actin
again65218112again
agin56132712agin
ai211288392_ai_
aid49269072_aid
ail37171042_ail
aim57858212_aim
ains46158882_ains
air38058392_air
airn46433832_airn
ais39083572_ais
ait38093902_ait
akin86328032akin
amain74922882amain
amin66042242amin
an211879072_a_n
ani37751172_ani
awn68035912_awn
ayin76331742ayin
bail65042802bail
bairn77515532bairn
bait66556002bait
ban58366832ba_n
bani65334952bani
barn66444642barn
basin75026922basin
bin56658632_bin
blain75421792blain
blin67228172blin
brain76229382brain
brin67038192brin
cab78355402ca_b
cabins104418912cabins
cabs86739422cabs
caca85528082caca
cad67456362ca_d
cade76443912cade
cadi75732172cadi
cadis84428492cadis
cads76144522cads
cafe95230322cafe
caff125631672caff
cage75339062cage
caging105321022caging
cagy106321992cagy
caids85226422caids
caiman103615662caiman
caird85717232caird
cairns85313302cairns
cairny11557822cairny
cajon144513902cajon
cake105439962cake
caking134624672caking
caky136222442caky
calf96339562calf
calif104929092calif
calix145317342calix
calk105527662calk
calkin123515492calkin
call66838672call
calm85032362calm
calo64936442calo
calx135722792calx
cam78058982ca_m
came87648752came
camion103917192camion
camo85731752camo
camp106336452camp
cams87047282cams
cane66653112cane
canid85526342canid
canine83826702canine
caning94128622caning
canna75919332canna
canny105817692canny
canon74725302canon
cans65050842cans
cant66362022cant
cap76758982ca_p
cape87242782cape
caph116623292caph
capiz18514562capiz
caplin103216302caplin
capo85829212capo
capon95221872capon
caps87147892caps
car59165562ca_r
carb85143162carb
card710245872card
care66968372care
carina84325322carina
caring95137992caring
cark105539272cark
carl65144782carl
carlin84421822carlin
carns75937562carns
carny105822922carny
carp85139812carp
carr65434702carr
cars67364762cars
cart66570342cart
casa65630862casa
case65848082case
casein83216452casein
cash96636282cash
casing94829102casing
casini84615862casini
casino84317552casino
cask105626432cask
cast67159902cast
cat58282342ca_t
cate66254592cate
cation83925502cation
catkin123512372catkin
catlin83819072catlin
cats66356342cats
caul65630002caul
cave95941262cave
cavie104621592cavie
cavil103816492cavil
caving124822612caving
cavy125920002cavy
caw86647932ca_w
cawing124322612cawing
caws96036102caws
cay87155982ca_y
cays95437672cays
ceil65725062ceil
chai95929902chai_
chaine115119222chaine
chains114819702chains
chair105519632chair
chais107530312chais
chi86228652chi_
chia96026622chia
chic115925202chic
chid106626402chid
china105022472china
chine105231722chine
chink145321592chink
chino105823312chino
chins105631462chins
chip116726422chip
chis95933312chis
chit96937462chit
chon96627792chon
ciao64924182ciao
cig67036182c_ig
cine66242942c_ine
cion613330912cion
cis57748032c_is
claim95616912claim
clan65633922clan
cline76428532cline
cling86424672cling
clink115320042clink
clip86924002clip
clon66232482clon
cocain101315012cocain
coif96337902coif
coign85013912coign
coil66439652coil
coins75834552coins
coir66327242coir
colin76231692colin
con510268022c_on
coni65534802coni
conin76232722conin
conn66229132conn
coon67248942coon
corn69945812corn
covin105621122covin
crib86323572crib
cris66233432cris
crit65743712crit
cuif96529132cuif
cuing85420192cuing
cumin94616972cumin
curn66731882curn
cutin75022772cutin
cyan96419622cyan
cyanin113911452cyanin
dais57040702dais
damn75724322damn
dan46859662da_n
darn56434622darn
dawn85624202dawn
din46459462_din
djin12911632djin
drain65222892drain
earn46737552earn
elain55324702elain
fagin9216572fagin
fail74840242fail
faint85837062faint
fair76332522fair
fan67158852fa_n
faun76226622faun
fawn105321952fawn
fin66458032_fin
foin77231562foin
gaen57329602gaen
gains65729512gains
gait56150192gait
gamin84422992gamin
gan48060122ga_n
gaun56427712gaun
gin46055752_gin
grain65126252grain
grin55733722grin
haen76229452haen
haik115526982haik
hail74839062hail
haint85436322haint
hair76330142hair
hin67559562_hin
in28150862__in
jail115529092jail
jin106443932_jin
join116724832join
kaif116933922kaif
kail85131492kail
kains96125642kains
kaon87521022kaon
karn86129412karn
kin76353962_kin
laic65931562laic
laid56439142laid
lair45934152lair
lapin75222922lapin
lawn75925632lawn
layin84720332layin
lin37967372_lin
loin46838722loin
maid75537632maid
mail65543432mail
maim85831472maim
mains75635092mains
mair66133762mair
man57465852ma_n
matin75132852matin
maun65727202maun
mavin105722952mavin
mawn94424132mawn
naan47621932naan
naif76839012naif
nail45838652nail
nan37854872na_n
paid75737482paid
paik105726802paik
pail66141832pail
pains75138282pains
paint75443692paint
pair66031512pair
pan58466442pa_n
patin76832852patin
pavin105623202pavin
pawn94625302pawn
pein65834942pein
pian66136092pian
pin57066722_pin
plain74823302plain
pyin96823232pyin
qaid146023842qaid
quin135823922quin
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rains55140232rains
rainy85921082rainy
rais45252622rais
ran38266612ra_n
rani46640102rani
ravin85624652ravin
rawin85521472rawin
rein46040892rein
rin36663182_rin
ruin47430512ruin
sabin74924942sabin
said55742112said
sail45447162sail
sains55639972sains
saint55147072saint
sarin55239252sarin
sasin54626572sasin
satin55935212satin
savin84625082savin
sawn75428162sawn
scan65530452sca_n
shin75634302shin
sin36265892_sin
skin85927522skin
slain54923572slain
spin66231302spin
stain55727932stain
swain84919052swain
tail45443652tail
tains54936322tains
taint55542282taint
takin94921302takin
tan37167562ta_n
tarn46842722tarn
thin76732382thin
tin36362172_tin
train56529112train
twain86313622twain
twin76023082twin
tyin76424002tyin
vail75432552vail
vair75624142vair
van66246322va_n
vein75625752vein
waif105836742waif
wail75238822wail
wains86930862wains
wair75830052wair
wait75553692wait
wan66761932wa_n
warn75239322warn
whin105225692whin
win66456292_win
yarn75230042yarn
yawn106219092yawn
yin67648732_yin
zayin174512042zayin
zein135620602zein
zin125643772_zin

Search took 4 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 Filter178691298720.1561145455.1
2DLD Change Limit298723532.65611247.0
3Display Results3533530.1732040.5
 (SQL Overall)1786913532.98559863.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.