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

396 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
hereto931369(None) 
thereto1038991thereto
whereto1346061whereto
beret74946362beret_
berets85822522berets
here76447102here__
hereat93527412hereat
hereby14468332hereby
herein93717792herein
hereinto1145432hereinto
hereof123212372hereof
hereon93914362hereon
heres86245902here_s
heresy125011232heresy
heretic12314832heretic
hereunto1143712hereunto
heriot9422342heriot
heritor10310562heritor
hero74635782her__o
hertz174919032her_tz
hetero9312632hetero
teredo7310782teredo
terete6319332terete
aerate64830553aerate
aerator7314843aerator
aero45435343aer__o
aerugo735803aerugo
arete56031353_arete
beet66457543be_et_
beets76131443be_ets
befret11315963befret_
befrets1237613befrets
beget85632553beget_
begets96215523begets
bento75922953be_nto
berate84729023berate
bereft114317303bereft
beretta938463beretta
berth104917883ber_th
beset76739133beset_
besets85718803besets
buret77444013buret_
burets84321263burets
caret75360563caret_
carets85330773carets
cento76625173ce_nto
cerate84829463cerate
cere66741473cere__
cereal8315833cereal
cered85227443cere_d
ceres75540013cere_s
cereus85215523cereus
cerite84724873cerite
cermet10321153cermet_
cermets1139713cermets
cero66329453cer__o
certes84623083certes
cheerio12379313cheerio
cheero114712933che_ero
cheroot12413693cheroot
chert105232103cher_t_
cherts115617233cher_ts
cherty144612473cher_ty
chevret153310633chevret_
chevrets16255323chevrets
credo84815563_credo
curet75447643curet_
curets84922343curets
deet57356583de_et_
deets65330243de_ets
delete73620703delete
demeton1037683demeton
derat65044083derat_
derate74531233derate
derats74625063derats
dere56845903dere__
egret63327313egret_
egrets72712243egrets
ere36352773_ere__
erect74129333_erect
erector93513803_erector
erects84116183_erects
erenow937373_erenow
ergo56420153_er_go
ergot65422893_ergot
erst47436433_erst_
erugo6369853_erugo
feet75352213fe_et_
fere76342233fere__
feres86038183fere_s
feretory1447503feretory
ferity122813343ferity
ferret93021173ferret_
ferrets103111393ferrets
ferrety13287013ferrety
foredo10510823foredo
forego1038903forego
foretop12117893foretop
fret75845043_fret_
frets85523403_frets
gelato73812953gelato
genet66038683genet_
genets75716663genets
gerent73223093gerent
gerents82612923gerents
gherao1036753gher_ao
ghetto1036073ghe_tto
greet65835323greet_
greets75117423greets
grego7310523_grego
haeres94017033haere_s
haet75659503h_aet_
haets86525123h_aets
hardtop1345053hardtop
hare76255733hare__
hared95742183hare_d
hareem114312063hareem
harem104924453hare_m
harems115513823harems
hares86255543hare_s
harlot94422803harlot
hart76865773har_t_
harts88441593har_ts
health124712143health
hearer94323643heare_r
hearers104319783hearers
heart85440743heart_
hearted113314023hearted
hearten102411753hearten
hearth125315213hearth
hearts96218943hearts
hearty126313633hearty
heat77061423he_at_
heated104525593heated
heater94828303heater
heath115724283he_ath
heats85838403he_ats
hebe96424703hebe__
hebes105521673hebe_s
hebetic1438633hebetic
hector113312653he_ctor
heder95623633hede_r
heders104119763heders
heed86437603he_e_d
heeds95420423he_eds
heel75034223he_e_l
heels85625533he_els
heeze175313483he_eze
heft106736293he_ft_
hefted134911423hefted
hefter124313923hefter
hefts116218153he_fts
hefty146112133he_fty
hegemon1345173hegemon
heired103813043heire_d
heiress1036813heiress
heist87030913heist_
heists96814633heists
helio85321193he_lio
hello86522983he_llo
helmet113718933helmet_
helmets12309073helmets
helo75332853h__elo
helot85332683helot_
helots95217703helots
heme95034413heme__
hemes105031083heme_s
hent76656383he_nt_
hented104218753hented
hents87330743he_nts
her66547813her___
herald10311343herald
herb94730963her__b
herbal112513493herbal
herbed123513453herbed
herbs105520503her_bs
herby134715313her_by
herd84933063her__d
herded114215643herded
herder104516463herder
herders113914123herders
herdic123112303herdic
herds96424683her_ds
heredes11313133heredes
heredity1546493heredity
heretics13310503heretics
heretrix1845123heretrix
hereupon1383143hereupon
herewith1755193herewith
heriots10312063heriots
heritors11310903heritors
herl75834553her__l
herls85226433her_ls
herm95636153her__m
herma105318883her_ma
hermae115314473hermae
hermai118912843hermai
hermetic15310243hermetic
hermit11519443hermit
hermits12312133hermits
herms105626433her_ms
hern76134893her__n
hernia9312293hernia
herns84825583her_ns
heroes94923823heroes
heroic113516923heroic
heroin94420593heroin
heron85025503her_on
herons94820543herons
heros84930863her_os
herpes115517323herpes
herpetic1547773herpetic
herry114922473her_ry
hers75844873her__s
herself1337623herself
herstory1446693herstory
hest75950773he_st_
hests85829933he_sts
het67674313h__et_
heteros10312683heteros
heth107028023h__eth
hets75547203h__ets
hewed125619433hewe_d
hewer115719933hewe_r
hewers123715273hewers
hexed165615763hexe_d
hexer155116683hexe_r
hexers165612753hexers
hexes155123043hexe_s
hire75538963hire__
hired95226263hire_d
hiree85427803hire_e
hirees95117293hirees
hirer85423123hire_r
hirers94518063hirers
hires86134343hire_s
hornet94926433hornet_
hornets104113553hornets
hornito1047073hornito
horst85833513horst_
horste94817413horste
horsts95817513horsts
hurst85527193hurst_
hursts97213093hursts
hurt77142573hur_t_
hurter93915853hurter
hurts86922823hur_ts
jereed144012063jereed
keet85347333ke_et_
keets95123483ke_ets
keto86223453__keto
leet45957903le_et_
leets54927123le_ets
legato72810953legato
lento57223393le_nto
meet65350553me_et_
meets74224613me_ets
memento11378133memento
mere67244443mere__
merely111312583merely
merer75126233mere_r
meres75143573mere_s
merest84725113merest
merino8315093merino
merit7339183merit_
merits8320873merits
merlot83217603merlot
nepeta837893nepeta
nereid7312923nereid
nereis6315343nereis
nerts55924983ner_ts
nertz145117453ner_tz
pareo74632603pare_o
pere66450263pere__
perea75026443pere_a
pereia85217983pereia
pereion9312043pereion
pereon83517453pereon
peres76246643pere_s
perfecto15105743perfecto
periti8319953periti
pernio8513143pernio
pert66759323per_t_
perter84422283perter
peseta8310573peseta
pesto75723723pe_sto
petto76021043pe_tto
phenetol1344063phenetol
presto84216203presto
pretor8315743_pretor
rato45436973__rato
rebato83714683rebato
recto74520803re_cto
redo56029363__redo
regret73723533regret_
regrets83212923regrets
relet54749823relet_
relets64025673relets
remet74843723remet_
repo66027543__repo
reread71715433reread
reredos838633reredos
rerent63832453rerent
rerents73319423rerents
reset55051863reset_
resets65427613resets
ret35982833__ret_
rete44944133__rete
retro55020953__retro
rets45352563__rets
revet84938843revet_
revets94022173revets
rewet85135153rewet_
rewets94617213rewets
rezero1578873rezero
roto45935053__roto
secret8325063secret_
secrete9311073secrete
secretor1045673secretor
secrets9311773secrets
sere46153473sere__
sered65737293sere_d
serein63318463serein
serene63522353serene
serer55935503sere_r
seres55448893sere_s
serest64831613serest
servo84516683ser_vo
sexto124415453se_xto
sheet84836953she_et_
sheets93918493she_ets
shegetz2044263shegetz
sherbet12311383sherbet_
sherbets1335213sherbets
shereef1337743shereef
sheroot10414373sheroot
stereo65317913stere_o
stretto737723stretto
surety93515003surety
teeth87315853te_eth
tenet55542213tenet_
tenets65518953tenets
tenuto648743tenuto
tercet83624913tercet_
tercets93512443tercets
teredos839173teredos
terret63425623terret_
terrets72913573terrets
there87527393there__
thereat104315243thereat
thereby1534633thereby
therefor1494453therefor
therein102310353therein
thereinto1243923thereinto
thereof13168063thereof
thereon10199263thereon
theres96525473there_s
thereunto1252653thereunto
torero6313203torero
treetop945523treetop
tret46653533_tret_
trets55928023_trets
uredo65112993_uredo
vegete1039483vegete
verite94323443verite
verity123714853verity
verset94327323verset_
versets103913093versets
verso85314633ver_so
verst84429373verst_
verste94515633verste
versts93914733versts
vert77249373ver_t_
vertex1637373vertex
verts85724733ver_ts
vertu85017613ver_tu
vervet124619063vervet_
vervets13419743vervets
veto76622993__veto
vireo84816453vire_o
weet75254153we_et_
weets85427723we_ets
were76238333were__
wert79749823wer_t_
where117019423where__
whereas13448903whereas
whereat134311923whereat
whereby1842913whereby
wherein13216593wherein
whereinto1552343whereinto
whereof16185463whereof
whereon13196503whereon
wheres125917433where_s
whereunto1551783whereunto
zero134822463zer__o
zeroth1837963zeroth

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 Limit1127163966.50017340.9
3Display Results3963960.1562538.5
 (SQL Overall)1786913966.79626293.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.