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

120 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
chains11481970(None) 
cains75334301c_ains
chain105723671chain_
chaine115119221chaine
chaines124518731chaines
chairs114916181chairs
chais107530311chai_s
chins105631461ch_ins
ains46158892__ains
blains84516372blains
brains85125472brains
cabins104418922cabins
caids85226432c_aids
cain65643912c_ain_
cairns85313302c_airns
cans65050852c_a_ns
carns75937562c_arns
chads116122232cha_ds
chafes145017912chafes
chaffs17459612chaffs
chafing163911492chafing
chagrins1437072chagrins
chai95929902chai__
chained133812692chained
chainsaw1642372chainsaw
chair105519632chai_r
chaise114916412chaise
chaises124317492chaises
chalks155412142chalks
champs154915682champs
chams126028502cha_ms
chang115418562cha_ng
changs125215372changs
chant105932692cha_nt
chants115020392chants
chaos105622862cha_os
chapes135421872chapes
chaps125326062cha_ps
charas114223612charas
chards125119732chards
chares115631802chares
charing133721322charing
charks155219702charks
charms135218842charms
charrs115219192charrs
chars105936642cha_rs
charts115823092charts
chases115128232chases
chasing133715892chasing
chasings14318252chasings
chasms135513142chasms
chats105730092cha_ts
chaunt11613492chaunt
chaunts1267082chaunts
chawing164813032chawing
chaws135022462cha_ws
chays135319742cha_ys
chazans21268122chazans
chias104625522ch_ias
chiaus113611312chiaus
chics123920942ch_ics
chin96934742ch_in_
china105022482ch_ina
chinas115119402ch_inas
chine105231722ch_ine
chines115029172ch_ines
chink145321592ch_ink
chinks155817572ch_inks
chino105823312ch_ino
chinos115018692ch_inos
chints115117832ch_ints
chips125721252ch_ips
chis95933312ch_i_s
chitins122713792chitins
chits105424572ch_its
choirs114911882choirs
chopins142312242chopins
churns114910232churns
claims105211572claims
clans75031012cla_ns
cocains111313922cocains
coins75834552c_oins
colins85229042colins
conins84327242conins
covins114618062covins
cumins103314932cumins
cutins83919982cutins
cyanins122910012cyanins
cyans105714812cya_ns
drains73719402drains
elains64919852elains
enchains1348522enchains
gains65729512_gains
grains74223092grains
haiks125120932_haiks
hails85231642_hails
haint85436322_haint
haints94417582_haints
hairs86225172_hairs
hins76448002_h_ins
kains96125652_kains
khans124615172kha_ns
mains75635112_mains
pains75138282_pains
plains85019592plains
rains55140232_rains
sains55639972_sains
shairns10276782shairns
sharns95516982sharns
shins85131042sh_ins
stains64923652stains
swains94513952swains
tains54936322_tains
theins95015422theins
thins85826332th_ins
trains64725342trains
twains95811182twains
unchains1338302unchains
wains86930872_wains
whins114922332wh_ins

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 Filter178691825510.376475242.0
2DLD Change Limit825511202.22037185.1
3Display Results1201200.0304000.0
 (SQL Overall)1786911202.62668046.8
 
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.