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

262 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
ransom8241094(None) 
hansom11219151hansom
random92513551random
ransoms92410161ransoms
transom948821transom
canso75019402canso_
cansos84915382cansos
fandom122110892fandom
fantom112110802fantom
hansoms12238522hansoms
ramson8310462ramson
rancor8810372rancor
randoms102112432randoms
ransomed1146932ransomed
ransomer1047882ransomer
transoms1048932transoms
also46423443_also_
ancon75718233_ancon
anion55028813_anion
annoy869713_annoy
anoa45634473_an_oa
anomy105113393_an_omy
anon46134853_an_on
ansa45927773_ans_a
ansae55720973_ansae
anyon85615223_anyon
arson55118833_arson
atom67824523_a_tom
axiom143913593_axiom
balsam105612233balsam
banco94019393banco_
bancos104713893bancos
bandog1038723bandog
banjo143812443banjo_
banjos15378893banjos
bans66555133bans__
bantam10314063bantam
basso76017283basso_
bassos85313703bassos
besom95716973_besom
bosom95516923_bosom
brans75437433brans__
candor94516423candor
cannon84514443cannon
cannot83616773cannot
canoe75627253can_oe
canon74725303can_on
cans65050843cans__
canst74932213cans_t
canto74931013canto_
canton85722993canton
cantor85621523cantor
cantos84826973cantos
canyon114512033canyon
carom95025563ca_rom
carrom10513403carrom
censor84011283censor
chanson1238043chanson
condom114215363condom
consol82614113consol
cranium11911103cranium
crannog1044243crannog
damson938063damson
danio6319783danio_
danios7314603danios
dans56748143dans__
fandoms13229473fandoms
fanion94514323fanion
fano75831683fan_o_
fanon84619013fan_on
fanos85926503fan_os
fans76247363fans__
fantod102010033fantod
fantoms12189153fantoms
fanum10313443fan_um
fathom1437473fathom
fatso85113493fatso_
fatsos9389423fatsos
ganof95420363gan_of
genom83716843gen_om
grandam1139393grandam
grandson1055413grandson
grans64832543grans__
grantor84010933grantor
granum9310913gran_um
handsome1447603handsome
hansa85416783hans_a
hansas94616043hansas
hanse85722793hans_e
hansel95214373hansel
hanses95022633hanses
jetsom15126143jetsom
lanose6313593lanose
lasso55015683lasso_
lassos64913813lassos
lissom837403lissom
madtom1138023madtom
mango85724313mango_
mangos94319333mangos
manioc103914823manioc
mano66536793man_o_
manor78023923man_or
manos74933613man_os
mans66354533mans__
manse75528223mans_e
manses84225513manses
mansion9611543mansion
mason74820183ma_son
nanism8311203nanism
nans46139393nans__
nom510450643__n_om
noncom1039683noncom
pans65855723pans__
pansy105717973pans_y
panto76129413panto_
pantos85222743pantos
pantoum1138703pantoum
parson83817903parson
passim10410283passim
phantom1436683phantom
racism103214193racism
racon75422143ra_con
racoon83814473racoon
radio64922493radio_
radios74018673radios
radium93513293radium
radome9511873ra_dome
radon64620503ra_don
rads56046603rads__
rags55448373rags__
ragtop936683ragtop
rainbow1243353rainbow
rains55140233rains__
rainstorm1144563rainstorm
rais45252623rais__
raise54828053rais_e
raised76120333raised
raiser66620103raiser
raises64826543raises
raisin62716923raisin
ram56867273ra___m
ramose8314403ramose
ramrod936833ramrod
rams65950773rams__
ramsons939563ramsons
ran38266613ran___
rance75028513ran_ce
rances84625443rances
ranch105019793ran_ch
rancho114310853rancho
ranchos123911393ranchos
rancid9513863rancid
rancors9811373rancors
rancour987133rancour
rand55839563ran__d
randan7315253randan
randomly1443793randomly
rands65930453ran_ds
randy95022083ran_dy
ranee55438103ran_ee
ranees64623963ranees
rang56939153ran__g
range64728413ran_ge
ranged84824313ranged
ranger73925523ranger
ranges73826923ranges
rangy95320383ran_gy
rani46640103ran__i
ranid66429333ran_id
ranids75118703ranids
ranis55235833ran_is
rank85135523ran__k
ranked114620743ranked
ranker105021903ranker
rankle103414883rankle
rankly133910453rankly
ranks95225733ran_ks
ransack1346463ransack
ransomers1146873ransomers
ransoming1256513ransoming
rant45864673ran__t
ranted74324703ranted
ranter63826823ranter
rants55935343ran_ts
ranula6311813ranula
raps66247733raps__
raptor83912823raptor
ras37575393ra_s__
rase46149983ra_s_e
rased65033933ra_sed
raser55633413ra_ser
rases55447213ra_ses
rash76039933ra_s_h
rasp66029163ra_s_p
rasps74316663ra_sps
raspy106511703ra_spy
rassle63813203rassle
ratio55227583ratio_
ration64226013ration
ratios64922673ratios
rato45436973ra_to_
ratoon64417373ratoon
ratos55528763ra_tos
rats46260373rats__
ratton64116123ratton
raws75238213raws__
rayon83815703ra_yon
rays77642353rays__
razor143012603ra_zor
reason62616333reason
renvoi945863renvoi
resod64720053r_esod
resow88217243r_esow
rhabdom1543383rhabdom
rins46153193rins__
rinse54820973rins_e
rinsed75016353rinsed
rinser64317213rinser
rinses64720383rinses
roans54926443roans__
rom59855633r___om
rondo65218373rondo_
rondos74616733rondos
ronion63315643ronion
ronyon9309133ronyon
room66235083r__oom
runs46438073runs__
sannop837373sannop
sans45153353sans__
sansar63613393sansar
sansei63411903sansei
santo56227283santo_
santol64515243santol
santos64421833santos
sensor63813833sensor
sensum849353sensum
som59153803___som
syncom1336093syncom
tandem9311403tandem
tango66921173tango_
tangos74216303tangos
tannoy958353tannoy
tans46154813tans__
tansy84514933tans_y
tanto55724943tanto_
tatsoi637263tatsoi
tensor63812673tensor
trangam1039353trangam
trans54933043trans__
transform1446193transform
transit7317163transit
uranism91112513uranism
uranium9610023uranium
vagrom1235943vagrom
vans76236723vans__
varoom11411413varoom
venom103914863ven_om
wagsome1345213wagsome
wanion93213063wanion
wans76452263wans__
wanton94413813wanton
winsome1237463winsome

Search took 7 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.1401276364.3
2DLD Change Limit1127162626.04618643.1
3Display Results2622620.0803275.0
 (SQL Overall)1786912626.26628517.6
 
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.