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

497 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
haltere10361470(None) 
halter94420881halter_
haltered123112551haltered
halteres113414591halteres
halters104619801halters
alter54828502_alter_
altered83215732_altered
alterer72713992_alterer
alters64924222_alters
falter94519052falter_
faltered122810982faltered
falterer11239852falterer
falters103916472falters
galere73716672gal_ere
hafter124815882hafter_
hafters134614332hafters
halberd1336042halberd
halbert12314502halbert
haler85033522hal_er_
halers94926912hal_ers
haleru94212072hal_eru
halted105019602halte_d
halvers133311422halvers
haptene123810932haptene
hater85034752ha_ter_
haters94930392ha_ters
hatter94724872hatter_
hatters104221522hatters
palter84423262palter_
paltered113012482paltered
palterer102411272palterer
palters94021682palters
salter64325082salter_
saltern74010652saltern
salters73622252salters
saltire73113032saltire
adhere10310333_adhere
after85719793_after_
afters94717073_afters
alder65421913_alder_
alders74218423_alders
alee46652323_al_e_e
alert54740653_al_ert
alkene104114003_alkene
allee54932123_alle_e
allege74314643_allege
allele64514563_allele
allure63012943_allure
altar55520643_altar_
altars64518153_altars
alterers82512493_alterers
ampere10514413_ampere
antre55224523_ant_re
apter76120203_apter_
artery9911453_artery
aster55434893_aster_
astern64815813_astern
asters65631603_asters
attire62412383_attire
austere7312993austere
baiter84422553baiter_
baiters94619303baiters
balder95318863balder_
baler75635273bal_er_
balers85626933bal_ers
balker124519163balker_
balkers134915723balkers
baller83825203baller_
ballers94421013ballers
banter84825333banter_
bantered113313633bantered
banterer102811773banterer
banters94623113banters
barter85525373barter_
bartered113113013bartered
barterer102711633barterer
barters94223033barters
baster85333593baster_
basters94930303basters
batter84928873batter_
battered113315053battered
batterer102713213batterer
batterie10711533batterie
batters94626013batters
battery124911813battery
belter84720963belter_
belters93819413belters
bolter83920753bolter_
bolters94017803bolters
caldera1037963caldera
calibre1136603calibre
calker124917083calker_
calkers134414693calkers
callee84327293calle_e
caller85125483caller_
callers94221963callers
calmer105216933calmer_
canter85230113canter_
cantered113415983cantered
canters94827723canters
capture1138903capture
carter84932273carter_
carters95327243carters
caster85232573caster_
casters94729893casters
cater74840703ca_ter_
catered103117763ca_tered
caterer92815933ca_terer
caters85336493ca_ters
cattery123811603cattery
cautery12349573cautery
chanter123919733chanter_
chanters134016723chanters
chapter144213853chapter_
chaptered17176783chaptered
chapters154012113chapters
charter123918303charter_
chartered15158383chartered
charterer14197323charterer
charters134115563charters
chaster124718503chaster_
chatter124416643chatter_
chattered15197983chattered
chatterer14196843chatterer
chatters134213933chatters
chattery16357273chattery
colter84625093colter_
colters93522433colters
culture939393culture
dafter104813343dafter_
darter75320363darter_
darters84017603darters
dater65332313da_ter_
daters74827363da_ters
easter65027983easter_
eastern74412533eastern
easters75125683easters
eater54639843ea_ter_
eaters65535943ea_ters
eatery95316353ea_tery
eglatere945143eglatere
elater64724203elater_
elaters74420183elaters
exalter1437563exalter_
exalters1536653exalters
facture12108923facture
faller94621233faller_
fallers103917993fallers
falser93912413falser_
falterers12238033falterers
faster94625773faster_
fatter94523213fatter_
filter94517633filter_
filtered12259043filtered
filterer11258143filterer
filters103816543filters
gaiter73819503gaiter_
gaiters83516533gaiters
galeae74717453gal_eae
galeres83514323gal_eres
galette84212693galette
gallery11468743gallery
galore73514843gal_ore
garter74420513garter_
gartered10319583gartered
garters84218223garters
gaster75027353gaster_
gasters85624283gasters
gater64533643ga_ter_
gaters74728633ga_ters
hachure1545723hachure
hackee154921833hacke_e
hacker154822693hacker_
hackers164619043hackers
hadjee174111823hadje_e
haeres94017033ha__eres
haftara13136093haftara
hafted134713833hafte_d
hailer94720343hailer_
hailers104017263hailers
halberds1435173halberds
halberts1335963halberts
hale76052833hal___e
haled95335823hal_e_d
hales85449843hal_e_s
halest94823273hal_est
halftime1643313halftime
halftone1445153halftone
halide103417993hal_ide
halite93624233hal_ite
halites103221193halite_s
hallel93514093halle_l
hallels103310133hallels
haloed104717593haloe_d
haloes94623863haloe_s
halt76056303halt___
haltering132212003haltering
halting114419073halting
haltless11308443haltless
halts85230103halt__s
halve114818923hal__ve
halved134813903halve_d
halves124717093halve_s
halyard1476973halyard
hammer138120033hammer_
hammered16218843hammered
hammerer15278143hammerer
hammers144216053hammers
hamper134518653hamper_
hampered16239923hampered
hamperer15379093hamperer
hampers143616943hampers
hamster12810423hamster_
hamsters13710423hamsters
hander104526433hander_
handers114224333handers
hanger104023253hanger_
hangers113120813hangers
hanker134622093hanker_
hankered16289443hankered
hankerer15248233hankerer
hankers144218133hankers
hanted104124313hante_d
hantle94318203hant_le
hapten115312983hapte_n
haptenes133810823haptenes
haptens124511343haptens
harder105022403harder_
hare76255733ha___re
harmer114719553harmer_
harmers124116593harmers
harper115018403harper_
harpers124916203harpers
hastate10313913hastate
haste85927863hast__e
hasted105125283haste_d
hasten95718563haste_n
hastened12239103hastened
hastener11259133hastener
hastens106214813hastens
hastes95727073haste_s
hastier103916623hastier_
hate78450173ha_t__e
hated95734023ha_te_d
hates86742573ha_te_s
hatless103813443hatless
hatlike143311713hatlike
hatred104814333ha_tred
hatted104921513hatte_d
hatteria1137863hatteria
hauberk1633463hauberk
hauler95015123hauler_
haulers104012443haulers
haulier1059943haulier_
hauliers1176713hauliers
haunter103111153haunter_
haunters11329533haunters
haute89521613haut__e
hauteur1033893hauteur
hauteurs1133733hauteurs
haver115124463ha_ver_
havered144011453ha_vered
haverel13397153ha_verel
havers124721483ha_vers
hawker164812663hawker_
hawkers174210333hawkers
hawser125910843hawser_
hawsers13409483hawsers
hayer114620243ha_yer_
hayers124415943ha_yers
haywire1644743haywire
hazer174820233ha_zer_
hazers184615953ha_zers
hazier184712403hazier_
healer94221803heal_er_
healers104319463heal_ers
heater94828303heater_
heaters104225213heaters
hectare1238463hectare
hefter124313923hefter_
hefters134312003hefters
hektare1435503hektare
heller93322513heller_
helleri10389973helleri
hellers103619833hellers
hellery13329213hellery
helper114313093helper_
helpers123311853helpers
here76447103h___ere
hetero9312633h_etero
hiller94421633hiller_
hillers103718723hillers
hilted104016043hilte_d
hinter94021303hinter_
hinters103719573hinters
hitter94419863hitter_
hitters104717583hitters
holder104619653holder_
holders113715903holders
holier94921623holier_
holler93520613holler_
hollered1237603hollered
hollers103818233hollers
holster103512213holster_
holstered1345873holstered
holsters113211933holsters
hooter94123923hooter_
hooters104520463hooters
hotter94720073hotter_
huller93919103huller_
hullers103616263hullers
hunter94817773hunter_
hunters103915723hunters
hurter93915853hurter_
hurters103413633hurters
jilter133512513jilter_
jilters144211953jilters
jolter133513093jolter_
jolters143711993jolters
kantele1138253kantele
kelter103214373kelter_
kelters113813753kelters
kilter103714343kilter_
kilters113813593kilters
lantern7310013lantern
laster64830633laster_
lasters75627693lasters
later54843923la_ter_
latter65027893latter_
malgre9299303mal_gre
mallee84525593malle_e
maltase938903maltase
malted94819853malte_d
malteds10377603malteds
maltier93015483maltier_
maltose939783maltose
master84831343master_
mastered112614003mastered
masters94628923masters
mastery124214323mastery
mater74438863ma_ter_
maters85032383ma_ters
matter84325343matter_
mattered112412903mattered
matters94421753matters
mattery123810713mattery
mature8313463ma_ture
melter83520113melter_
melters93918313melters
milter84921233milter_
milters93619083milters
molter84119423molter_
molters93816973molters
multure939183multure
natter64420743natter_
nattered92011623nattered
natters73718063natters
nature6311263na_ture
oater55433733oa_ter_
oaters65029783oa_ters
paleae84820293pal_eae
paler75436933pal_er_
palette93613983palette
palier85023563palier_
palmer105816543palmer_
palmers113513623palmers
palterers11249533palterers
paltry114910403palt_ry
parterre1036983parterre
paster85734373paster_
pastern94415063pastern
pasters94531733pasters
pasture9311463pasture
pater74740723pa_ter_
paters84935823pa_ters
pattee84323383patte_e
patter84628263patter_
pattered112714203pattered
patterer103112173patterer
pattern93712053pattern
patters94825193patters
pelter83321623pelter_
peltered112510443peltered
pelters93720313pelters
phatter123810203phatter_
philter12108213philter_
philtered1545493philtered
philters1398173philters
philtre12105213philt_re
plater84427693plater_
platers93924083platers
psalter9247813psalter_
psalters10227713psalters
psaltery13224733psaltery
rafter94517583rafter_
raftered1237663raftered
rafters103715633rafters
ranter63826823ranter_
ranters73323643ranters
rapture937383rapture
raster64731443raster_
rasters74629023rasters
rater54943283ra_ter_
raters63936573ra_ters
ratter64326313ratter_
ratters74422473ratters
realter73716313realter_
realtered1037893realtered
realters83614043realters
salted74121203salte_d
salterns8388893salterns
saltest71916513saltest
saltie63422423salt_ie
saltier74318633saltier_
saltiers83411953saltiers
saltine75018563saltine
saltires83112423saltires
saltpetre1152433saltpetre
saluter73512453saluter_
saluters8319853saluters
salver94617753salver_
salvers103916003salvers
santera7311303santera
santero7311133santero
satire63218003sa_tire
sauterne846253sauterne
shalier103116423shalier_
shatter103615693shatter_
shattered13178203shattered
shatterer12177203shatterer
shatters113313903shatters
shelter103214953shelter_
sheltered1335573sheltered
shelterer1245033shelterer
shelters113412803shelters
slater64429183slater_
slaters73123723slaters
stere55328543__stere
taler56034863tal_er_
talers64628143tal_ers
talker103916223talker_
talkers113513213talkers
taller63721963taller_
tartare73012683tartare
tarter64023563tarter_
taster64930573taster_
tasters74225643tasters
tater54138613ta_ter_
taters64932193ta_ters
tatter64024573tatter_
tattered92011443tattered
tatters74520483tatters
tauter64318023tauter_
thaler94613103thal_er_
thalers106212263thal_ers
tilter63417693tilter_
tilters73315933tilters
unaltered1037723unaltered
valuer93911443valuer_
valuers10328943valuers
vaster94521023vaster_
vaulter10257713vaulter_
vaulters11206163vaulters
vulture1036763vulture
wafter124114613wafter_
wafters134112813wafters
wafture1334853wafture
waiter94321253waiter_
waitered1238753waitered
waiters104218623waiters
waler84229263wal_er_
walers94824463wal_ers
walker133913993walker_
walkers143411473walkers
walleye1336243walleye
waltzer1934383waltzer_
waltzers2034003waltzers
wanter94423053wanter_
wanters104420093wanters
waster95228943waster_
wasterie111211583wasterie
wasters104026593wasters
wastery134610993wastery
water84733313wa_ter_
watered113014953wa_tered
waterer103314073wa_terer
waters95030623wa_ters
watery123914493wa_tery
watter93221983watter_
welter93417383welter_
weltered12238433weltered
welters103516063welters
whaler124611973whal_er_
whalers13529703whal_ers
yatter94116213yatter_
yattered12239533yattered
yatters103914623yatters

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274977.42318055.6
3Display Results4974970.1702923.5
 (SQL Overall)1786914977.74923059.9
 
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.