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

253 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
hansom1121915(None) 
hansoms12238521hansoms
ransom82410941ransom
canso75019402canso_
cansos84915382cansos
chanson1238042chanson
fandom122110892fandom
fantom112110802fantom
handsome1447602handsome
hansa85416782hans_a
hansas94616042hansas
hanse85722792hans_e
hansel95214372hansel
hanses95022632hanses
phantom1436692phantom
random92513552random
ransoms92410162ransoms
transom948822transom
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
bans66555143bans__
bantam10314063bantam
basso76017283basso_
bassos85313703bassos
besom95716973_besom
bosom95516923_bosom
candor94516423candor
cannon84514443cannon
cannot83616773cannot
canoe75627253can_oe
canon74725303can_on
cans65050853cans__
canst74932213cans_t
canto74931013canto_
canton85722993canton
cantor85621523cantor
cantos84826973cantos
canyon114512033canyon
carom95025563ca_rom
carrom10513403carrom
censor84011293censor
chansons1337473chansons
chantor123710313chantor
chasm125518793cha_s_m
chrisom1466623chrisom
condom114215363condom
consol82614113consol
damson938063damson
danio6319783danio_
danios7314603danios
dans56748153dans__
fandoms13229473fandoms
fanion94514323fanion
fano75831693fan_o_
fanon84619013fan_on
fanos85926503fan_os
fans76247373fans__
fantod102010033fantod
fantoms12189153fantoms
fanum10313443fan_um
fathom1437473fathom
fatso85113493fatso_
fatsos9389423fatsos
ganof95420363gan_of
genom83716843gen_om
haboob1377883haboob
hadron102913753hadron
hadst93220223hads_t
haem95730983ha__em
haes77651023haes__
hafnium1544243hafnium
hagdon1188283hagdon
hags86740843hags__
hahnium1544433hahnium
hahs108333363hahs__
hakeem15407383hakeem
hakim14311833ha_kim
halidom1386443halidom
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
halm95834973ha__lm
halo76437323ha_lo_
halon86124863ha_lon
halos85230253ha_los
ham86363283ha___m
hammam12419333hammam
hams96446133hams__
hance105424153han_ce
hances115621283hances
hand86833713han__d
handax1749583handax
handed114919983handed
hander104526433hander
handle104219293handle
handloom1444613handloom
handoff1756483handoff
handout11314103handout
hands95327383han_ds
handsaw1435533handsaw
handsel11308723handsel
handset113016823handset
handsomer1545453handsomer
handy125520873han_dy
hang85535553han__g
hangar104114513hangar
hangdog1343133hangdog
hanged114222393hanged
hanger104023253hanger
hangout11411393hangout
hangs95726723han_gs
hangul1049213hangul
hangup1277293hangup
haniwa1236743haniwa
hank115134143han__k
hanked144220603hanked
hanker134622093hanker
hankie133915713hankie
hanks126226863han_ks
hanky155418293han_ky
hansels104011653hansels
hant75461593han__t
hanted104124313hanted
hantle94318203hantle
hants86335403han_ts
hao67251123ha__o_
haps96443463haps__
harbor11410723harbor
hareem114312063hareem
harem104924453ha_rem
harlot94422803harlot
harm95637793ha__rm
harrow122610773harrow
harsh116418053hars_h
has67372653ha_s__
hash106936503ha_s_h
hasp96627293ha_s_p
hasps105114643ha_sps
hassel95614213hassel
hassium1236133hassium
hassle93711593hassle
hassock1645443hassock
hast76259483ha_s_t
haste85927863ha_ste
hasty115718763ha_sty
hatbox1835133hatbox
hats76858253hats__
haulm104415413ha_ulm
hausen9610383hausen
havior1248203havior
havoc1337183ha_voc
haws106439443haws__
hawse116015123haws_e
hawser125910843hawser
hawses125113993hawses
haymow1773683haymow
hays106138073hays__
hens75642573hens__
hins76447993hins__
honor85718623hon_or
hons77350783hons__
huns76136933huns__
hyson1138693h_yson
hyssop1443413hyssop
jetsom15126143jetsom
khans124615173khans__
lanose6313593lanose
lasso55015683lasso_
lassos64913813lassos
lissom837403lissom
madtom1138023madtom
mango85724323mango_
mangos94319333mangos
manioc103914823manioc
mano66536813man_o_
manor78023933man_or
manos74933623man_os
mans66354553mans__
manse75528233mans_e
manses84225513manses
mansion9611543mansion
mason74820183ma_son
nanism8311203nanism
nans46139403nans__
nom510450643__n_om
noncom1039683noncom
pans65855733pans__
pansy105717973pans_y
panto76129413panto_
pantos85222743pantos
pantoum1138703pantoum
parson83817903parson
passim10410283passim
phantoms1545973phantoms
phenom1339473phen_om
ramson8310463ramson
rancor8810373rancor
randoms102112433randoms
ransomed1146933ransomed
ransomer1047883ransomer
rhabdom1543383rhabdom
sannop837373sannop
sans45153363sans__
sansar63613393sansar
sansei63411903sansei
santo56227283santo_
santol64515243santol
santos64421833santos
sensor63813843sensor
sensum849353sensum
shahdom1643973shahdom
shalom11810923sha_lom
som59153813___som
syncom1336093syncom
tandem9311403tandem
tango66921173tango_
tangos74216303tangos
tannoy958353tannoy
tans46154823tans__
tansy84514933tans_y
tanto55724943tanto_
tatsoi637263tatsoi
tensor63812673tensor
transoms1048933transoms
vagrom1235943vagrom
vans76236733vans__
varoom11411413varoom
venom103914863ven_om
wagsome1345213wagsome
wanion93213063wanion
wans76452273wans__
wanton94413813wanton
winsome1237463winsome

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.376475242.0
2DLD Change Limit1127162534.95322757.1
3Display Results2532530.0763328.9
 (SQL Overall)1786912535.40533060.3
 
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.