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

258 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
chins10563146(None) 
cains75334301cains
chains114819701chains
chias104625521chias
chics123920941chics
chin96934741chin_
china105022481china
chinas115119401chinas
chine105231721chine
chines115029171chines
chink145321591chink
chinks155817571chinks
chino105823311chino
chinos115018691chinos
chints115117831chints
chips125721251chips
chis95933311chi_s
chits105424571chits
coins75834551coins
hins76448001_hins
shins85131041shins
thins85826331thins
whins114922331whins
aching126521972aching
actins86321102actins
ahing98928352ahing
ahis76135382ahi_s
ains46158892_ains
amins75534322amins
ayins85321612ayins
bins66548262_bins
brins75533972brins
cabins104418922cabins
caids85226432caids
cain65643912cain_
cairns85313302cairns
cans65050852c_ans
carns75937562carns
ceils75019402ceils
chads116122232chads
chain105723672chain_
chaine115119222chaine
chaines124518732chaines
chairs114916182chairs
chais107530312chais
chams126028502chams
chang115418562chang
changs125215372changs
chant105932692chant
chants115020392chants
chaos105622862chaos
chaps125326062chaps
chars105936642chars
chats105730092chats
chaws135022462chaws
chays135319742chays
chefs136214662chefs
chess105016922chess
chews135418512chews
chi86228652chi__
chia96026622chi_a
chiao105618362chiao
chiasm13449102chiasm
chiaus113611312chiaus
chic115925202chi_c
chica125818262chica
chicas135916472chicas
chick165419132chick
chicks175317592chicks
chico124218252chico
chicos134614832chicos
chid106626412chi_d
chide115321022chide
chides124620472chides
chief134419482chief
chiefs14509652chiefs
chiel104918972chiel
chiels115115932chiels
child114516222child
chile105626892chile
chiles115425302chiles
chili106218482chili
chilis115517872chilis
chill105619872chill
chills114717702chills
chimb144813562chimb
chimbs153910302chimbs
chime125322592chime
chimes134922572chimes
chimp145216472chimp
chimps155713662chimps
chinch163911242chinch
chined125620062chined
chinky185610542chinky
chintz204212032chintz
chip116726422chi_p
chirk144516182chirk
chirks155414842chirks
chirm125317062chirm
chirms135113982chirms
chiro105320342chiro
chiros114617772chiros
chirp124717162chirp
chirps135414002chirps
chirr105015902chirr
chirrs114514982chirrs
chiru105317152chiru
chirus114615692chirus
chit96937462chi_t
chitins122713792chitins
chitons122611912chitons
chive135117622chive
chives144317592chives
chivy164810362chivy
choirs114911882choirs
chon96627792chon_
chopins142312242chopins
chops125019872chops
chows135618202chows
chubs125412622chubs
chugs115511942chugs
chums125015832chums
chunk144812382chunk
chunks154210332chunks
churns114910232churns
cigs75625112c_igs
cine66242952c_ine
cines75239682c_ines
cions75222852cions
cis57748042c_i_s
clans75031012clans
cline76428532cline
clines84926042clines
cling86424672cling
clings95716212clings
clink115320042clink
clinks125815062clinks
clips96018302clips
clons75228132clons
cochins141413102cochins
coifs105718702coifs
coigns94410062coigns
coils75030082coils
coin66645352coin_
coirs75221052coirs
colins85229042colins
conins84327232conins
conns75024232conns
cons66057692c_ons
coons76737282coons
corns76034762corns
covins114618062covins
cribs94516752cribs
cries75438402cries
cris66233432cri_s
crits75527572crits
cuifs104814692cuifs
cuing85420192cuing
cumins103314932cumins
curns74924282curns
cutins83919982cutins
cyans105714812cyans
dins56652052_dins
djins1368452djins
eching126315562eching
echini114710432echini
echinus1236202echinus
fins75849102_fins
foins85523382foins
gains65729512gains
ghis85020162ghi_s
gins55543962_gins
grins65427222grins
hens75642572_hens
hies74842842_hies
hims95230982_hims
hin67559572_hin_
hind85529762_hind
hinds96721482_hinds
hint77455752_hint
hints87330622_hints
hips96433712_hips
his66359512_hi_s
hisn79620942_hisn
hiss75629222_hiss
hits75545142_hits
hons77350782_hons
huns76136932_huns
ins35945612__ins
jins115635022_jins
joins125818412joins
kains96125652kains
khans124615172khans
khis117017992khi_s
kins85747922_kins
lins47059062_lins
loins56728422loins
mains75635112mains
ohias84415572ohias
ohing96018812ohing
pains75138282pains
peins76128062peins
phis95724902phi_s
phons105221142phons
pins65558462_pins
pyins105815862pyins
quins144819852quins
rains55140232rains
reins56234562reins
rhino84614322rhino
rhinos94411122rhinos
rins46153202_rins
ruins55822032ruins
sains55639972sains
shies86136552shies
shims104422552shims
shin75634312shin_
shine85533092shine
shines95028912shines
shiny115122142shiny
ships105123772ships
shits84731172shits
shivs115018802shivs
shuns85018142shuns
sins46755282_sins
skins94723472skins
spins75327982spins
tains54936322tains
theins95015422theins
thens85921832thens
thin76732392thin_
thine85026862thine
thing96622982thing
things104914302things
think125018802think
thinks134613362thinks
this76027382thi_s
tins45251312_tins
twins85118982twins
urchins1238862urchins
veins84620492veins
wains86930872wains
whens114618762whens
whids125413992whids
whigs125612642whigs
whims134515332whims
whin105225692whin_
whine116022812whine
whines125120102whines
whiny144915572whiny
whips134917082whips
whirs115218092whirs
whits115923822whits
wins75949182_wins
yins75335132_yins
zechins21137122zechins
zeins144715392zeins
zins135735012_zins

Search took 3 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.356501941.0
2DLD Change Limit538002582.15624953.6
3Display Results2582580.0634095.2
 (SQL Overall)1786912582.57569394.6
 
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.