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

227 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
urchin113874(None) 
urchins1238861urchins
archil11611572archil
archine125817052archine
arching136216692arching
archon11311752archon
arshin9312172arshin
chin96934742__chin
cochin131313202cochin
lurching14277332lurching
orcein838182orcein
orchid1289572orchid
orchil1158652orchil
orchis11710772orchis
orcin72716572orc_in
ruching133612932ruching
unchain1238942unchain
unchic1338642unchic
zechin20137702zechin
aching126521973_aching
actin74922553_actin
arch98628443arch__
archaic1438823archaic
archean1269123archean
arched125717323arched
archer115016243archer
arches114822043arches
archils12510533archils
archines133815253archines
archings14499863archings
archive154610483archive
archly1437353archly
archons12311583archons
arcing95819643arc_ing
arcking145811963arcking
arcsine94512393arcsine
arctic10313513arctic
arshins10312573arshins
baching156017753baching
barchan1469133barchan
birchen14347883birchen
birching16328463birching
brachia141910423brachia
brain76229383br_ain
brechan1437223brechan
brin67038193br__in
bromin102615693bromin
brucin1049133brucin
bruin75818333br_uin
bunching163410703bunching
burin75626063bur__in
burthen1236363burthen
caching156317503caching
cain65643913__cain
chain105723673__chain
chi86228653__chi_
chia96026623__chia
chic115925203__chic
chid106626403__chid
china105022483__china
chine105231723__chine
chink145321593__chink
chino105823313__chino
chins105631463__chins
chip116726423__chip
chis95933313__chis
chit96937463__chit
chon96627793__chon
churching2055083churching
cocain101315013cocain
cochins141413103cochins
coin66645353__coin
cretin82917913cretin
crocein1138073crocein
curch124415413curch__
curches143512743curches
curtain9319793curtain
cyclin1339273cyclin
drain65222893dr_ain
eching126315563_eching
echini114710433_echini
enchain1248863enchain
errhine1036593errhine
etching134511843etching
ficin103516723fic_in
fuchsin15124373fuchsin
gradin83517483gradin
grain65126253gr_ain
gratin74520583gratin
grin55733723gr__in
groin65521083gr_oin
hin67559563___hin
hunching17309113hunching
hutching17318643hutching
inching134414323inching
ischia1136393ischia
itching134011683itching
kachina1637663kachina
kuchen1536653kuchen
larchen12479633larchen
leching134613653leching
lectin82515013lectin
lichen114012743lichen
lichi104412953lichi_
lichis115212593lichis
lochan1139093lochan
lochia1158313lochia
lunching143110003lunching
lurch104814633lurch__
lurched13358033lurched
lurcher12338133lurcher
lurches123311663lurches
machine14313493machine
marchen143312073marchen
marching164312193marching
miching152911803miching
morphin1439003morphin
mucin93116823muc_in
mulching16287103mulching
munching16299973munching
munchkin1943233munchkin
murein8311763mur_ein
murrain937763murrain
murrhine1344313murrhine
mutchkin1943023mutchkin
narcein936293narcein
niching133612433niching
orceins937743orceins
orchids1377213orchids
orchils1277703orchils
orcins83313433orc_ins
ordain7810403ordain
origin7311033origin
orphan1137733orphan
orphic1368323orphic
orpin73415533or_pin
ouching134314903ouching
outchid1338723outchid
parching164313053parching
pechan13511543pechan
peching154513903peching
pectin102615533pectin
perching163711633perching
prochain1548483prochain
prochein1547523prochein
punching163310123punching
purin75527593pur__in
purlin83615863pur_lin
purloin9107493purloin
rachis114017653rachis
rain46251733_r_ain
ravin85624653_ravin
rawin85521473_rawin
recoin84320293recoin
rein46040893_r_ein
renin54830033_renin
repin75324703_repin
resin54131053_resin
rewin85623963_rewin
rhino84614323_r_hino
richen113812513richen
ricin74620213_ricin
rin36663183_r__in
robin74820283_robin
rosin55325313_rosin
ruche104216763ruch_e
ruched124314633ruched
ruches114819583ruches
ruchings14287073ruchings
rucking143216673rucking
ruction93611613ruction
ruin47430513_r_uin
rushing113817703rushing
rutin55421343_rutin
shin75634313__shin
techie11511723techie
thin76732393__thin
tocsin8311003tocsin
torching142510083torching
torchon1237363torchon
train56529113tr_ain
trichina1348093trichina
trochil1258713trochil
tropin83316753tropin
tuchun1145443tuchun
unakin10310963unakin
unchains1338303unchains
unchair1236163unchair
unci65019463unc_i_
uncia75015163unc_ia
uncini8310153unc_ini
unclip1046993unclip
uncoil8811853uncoil
unction9310663unction
unhip10178823u_nhip
unpin72613243u_npin
unship1148033unship
unthink1457003unthink
upcoil10126193upcoil
uracil8311543uracil
uraei53016083uraei_
urania62516123urania
uranic82315183uranic
urari54619963urari_
uraris63817273uraris
uratic83016363uratic
urban72013863ur_ban
urbia7311143ur_bia
uredia73610063uredia
ureic74514463ur_eic
uremia82910893uremia
uremic103410513uremic
urethan1045473urethan
uretic82914353uretic
urging83413123ur_ging
uric63624943ur__ic
uridine81311213uridine
urine55026603ur__ine
urn35731473ur___n
urping93914053ur_ping
ursid6311483ur_sid
ursine64114123ur_sine
whin105225693__whin
within123611383within
zecchin2343703zecchin
zechins21137123zechins
zucchini2442153zucchini

Search took 6 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 Filter1786911127160.436409841.7
2DLD Change Limit1127162274.89023050.3
3Display Results2272270.0633603.2
 (SQL Overall)1786912275.38933158.5
 
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.