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

184 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
hanse8572279(None) 
hance105424151hance
hansa85416781hansa
hansel95214371hansel
hanses95022631hanses
hawse116015121hawse
manse75528231manse
ane37866952_an_e
anes45255932_anes
anise55129712_anise
ansa45927772_ansa
ansae55720972_ansae
ante46538902_ante
apse67725382_apse
arse46539272_arse
bane65250432ban_e
banes74945582banes
bans66555142bans_
base64847022ba_se
cane66653122can_e
canes75350372canes
canoe75627252canoe
cans65050852cans_
canso75019402canso
canst74932212canst
carse74934332carse
case65848082ca_se
cause75225352cause
cense75121402cense
chaise114916412chaise
chance134617092chance
change124116752change
chase105127122cha_se
chasse115114602chasse
dance85223132dance
dans56748152dans_
dense65923502dense
ease45042332ea_se
false84818122false
fane75343572fan_e
fanes84639892fanes
fans76247372fans_
gane55145302gan_e
hade85440202ha_de
hades96035112hades
hadst93220222hadst
hae67364002ha__e
haes77651022haes_
hags86740842hags_
hahs108333362hahs_
hajes155420942hajes
hake115637842ha_ke
hakes126034302hakes
hale76052832ha_le
hales85449842hales
halve114818922halve
hame97043132ha_me
hames106138702hames
hams96446132hams_
hances115621282hances
hand86833712han_d
handed114919982handed
hander104526432hander
handle104219292handle
hands95327382hands
handsel11308722handsel
handset113016822handset
handy125520872handy
hang85535562han_g
hanged114222402hanged
hanger104023262hanger
hangs95726732hangs
hank115134142han_k
hanked144220602hanked
hanker134622092hanker
hankie133915712hankie
hanks126226862hanks
hanky155418292hanky
hansas94616042hansas
hansels104011662hansels
hansom11219152hansom
hant75461592han_t
hanted104124312hanted
hantle94318202hantle
hants86335402hants
haole84820082haole
haps96443462haps_
hare76255732ha_re
hares86255542hares
harsh116418052harsh
has67372652ha_s_
hash106936502ha_sh
hasp96627292ha_sp
hassel95614212hassel
hassle93711592hassle
hast76259482ha_st
haste85927862haste
hate78450172ha_te
hates86742572hates
hats76858252hats_
hausen9610382hausen
haute89521612haute
have106137072ha_ve
haves116034872haves
haws106439442haws_
hawser125910842hawser
hawses125113992hawses
hays106138072hays_
haze164833392ha_ze
hazes174928322hazes
hearse94114282hearse
hence104920052hence
henge94819832henge
hens75642572hens_
hinge95323452hinge
hins76448002hins_
hoarse94411322hoarse
hoise85224772hoise
hone77549322hon_e
hones88144492hones
hons77350782hons_
horse86132652horse
hose76547242h_ose
house89131422house
huns76136932huns_
jane115031482jan_e
janes124928122janes
kane85133982kan_e
kanes95529372kanes
khans124615172khans_
lance75126722lance
lane45153332lan_e
lanes54946792lanes
lanose6313592lanose
lapse74917682lapse
lase46148512la_se
lense54523432lense
mane65052032man_e
manes76648962manes
mange84930202mange
mans66354552mans_
manses84225512manses
marse76231152marse
masse75125292masse
mense75025632mense
nance74721842nance
nans46139402nans_
paise75028332paise
pane64950292pan_e
panes76148692panes
panne76623652panne
pans65855732pans_
pansy105717972pansy
parse75236992parse
pase65346862pa_se
passe75525692passe
pause75021832pause
phase104617212pha_se
raise54828052raise
rance75028512rance
ranee55438102ranee
range64728422range
rase46149982ra_se
rinse54820972rinse
sane45954342san_e
sanes55649072sanes
sans45153362sans_
sansei63411902sansei
sense55526822sense
tans46154832tans_
tansy84514942tansy
tasse54821842tasse
tawse85616502tawse
tense55225842tense
thane86122532than_e
thanes94918982thanes
valse85117522valse
vane75534692van_e
vanes85130982vanes
vans76236742vans_
vase75629652va_se
wane76344722wan_e
wanes85040882wanes
wans76452272wans_

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.330541487.9
2DLD Change Limit538001841.82629463.3
3Display Results1841840.0632920.6
 (SQL Overall)1786911842.21980527.7
 
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.