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

247 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
halbert1231450(None) 
halberd1336051halberd
halberts1335971halberts
albeit8314342_albeit
alert54740652_al_ert
filbert12411642filbert
gilbert10310762gilbert
halberds1435182halberds
haler85033522hal_er_
halers94926912hal_ers
haleru94212072hal_eru
halest94823272hal_est
halter94420882halter_
haltere103614702haltere
halters104619802halters
halvers133311422halvers
hauberk1633462hauberk
lambert113617112lambert
abet610547943_a_be_t
abler75624313_abler_
ablest84721833_ablest
abort76133583_a_bort
advert103215783_advert
albedo956123_albedo
alder65421913_alder_
alders74218423_alders
alerts64418223_al_erts
alter54828503_alter_
alters64924223_alters
amber94523213_amber_
ambers104519583_ambers
ambery133811133_ambery
assert64922583_assert
avert86029493_a_vert
balder95318863balder_
baldest102313533baldest
baler75635273bal_er_
balers85626933bal_ers
balker124519163balker_
balkers134915723balkers
baller83825203baller_
ballers94421013ballers
ballet84733973balle_t
barber104419323barber_
barbers114317503barbers
barbet104427883barbe_t
caber95126833ca_ber_
cabers105023923ca_bers
cabler104519173cabler_
cablers114416713cablers
cablet104429463cable_t
caldera1037963caldera
caliber1139733caliber_
calibers1238523calibers
calker124917083calker_
calkers134414693calkers
caller85125483caller_
callers94221963callers
callet84536763calle_t
calmer105216933calmer_
calmest11312343calmest
camber124418483camber_
cambers134017443cambers
chalet113825993chal_e_t
chamber164011063chamber_
chambers173410623chambers
culvert123011773culvert
dabber114816963dabber_
dabbers123813213dabbers
dauber94112013dauber_
daubers104610423daubers
daubery13396213daubery
fabber134814113fabber_
fabbest1438033fabbest
fabler116115813fabler_
fablers124812613fablers
faller94621233faller_
fallers103917993fallers
falser93912413falser_
falsest10310013falsest
falter94519053falter_
falters103916473falters
filberts1334993filberts
gabbart1248883gabbart
gabber114916603gabber_
gabbers124612833gabbers
galere73716673gal_ere
gallery11468743gallery
gallet73630853galle_t
gilberts1134183gilberts
habit103027023ha_b_it
hacker154822693hacker_
hackers164619043hackers
haddest122711993haddest
haet75659503ha__e_t
haffet15311703haffe_t
hafter124815883hafter_
hafters134614333hafters
hagberry1742903hagberry
hagborn1344953hagborn
hagbut1278913hagb_ut
hailer94720343hailer_
hailers104017263hailers
hale76052833hal_e__
haled95335823hal_e_d
hales85449843hal_e_s
halfbeak2042373halfbeak
halibut1289053halibut
hallel93514093halle_l
hallels103310133hallels
hallot95426783hal_lot
haloed104717603haloe_d
haloes94623863haloe_s
halt76056303hal___t
halted105019603halte_d
haltered123112553haltered
halteres113414593halteres
halve114818923halve__
halved134813903halve_d
halves124717093halve_s
halyard1476973halyard
hamburg1544123hamburg
hamlet113722793hamle_t
hammer138120033hammer_
hammers144216063hammers
hamper134518653hamper_
hampers143616953hampers
hander104526433hander_
handers114224333handers
hanger104023253hanger_
hangers113120813hangers
hanker134622093hanker_
hankers144218133hankers
harbor11410723harbor_
harbors12412413harbors
harder105022403harder_
hardest113118413hardest
harmer114719553harmer_
harmers124116593harmers
harper115018403harper_
harpers124916203harpers
hart76865773ha___rt
harvest132112753harvest
haslet93222713hasle_t
hater85034753ha_ter_
haters94930403ha_ters
hatter94724873hatter_
hatters104221523hatters
hauberks1742993hauberks
hauler95015123hauler_
haulers104012443haulers
haulier1059943haulier_
hauliers1176713hauliers
haver115124463ha_ver_
havers124721483ha_vers
hawker164812663hawker_
hawkers174210333hawkers
hawser125910843hawser_
hawsers13409483hawsers
hayer114620243ha_yer_
hayers124415943ha_yers
hazer174820233ha_zer_
hazers184615953ha_zers
hazier184712403hazier_
haziest193313003haziest
healer94221803heal_er_
healers104319463heal_ers
hellbent1345743hellbent
heller93322513heller_
helleri10389973helleri
hellers103619833hellers
hellery13329213hellery
helmet113718933helme_t
helper114313093helper_
helpers123311853helpers
hiller94421633hiller_
hillers103718733hillers
hobber134114633hobber_
hobbers143512343hobbers
holder104619653holder_
holders113715903holders
holier94921623holier_
holiest104319623holiest
holler93520613holler_
hollers103818233hollers
howbeit1545663howbeit
huller93919103huller_
hullers103616263hullers
jabber173713643jabber_
jabbers183610583jabbers
labret8320223la_bret
lambent113711303lambent
lamber104418493lamber_
lambers113817113lambers
lamberts12348793lamberts
malapert1249793malapert
mallet84433053malle_t
nabber104913543nabber_
nabbers113710463nabbers
paler75436933pal_er_
palest83926223pal_est
palet74650803pal_e_t
palier85023563palier_
paliest93021603paliest
pallet84232653palle_t
palmer105816543palmer_
palmers113513623palmers
palter84423263palter_
palters94021683palters
rabbet103818653rabbe_t
saber75330243sa_ber_
sabers85224733sa_bers
salient7419763salient
sallet63734543salle_t
salter64325083salter_
saltern74010653saltern
salters73622253salters
saltest71916513saltest
salver94617753salver_
salvers103916003salvers
shalier103116423shalier_
shaliest111415053shaliest
sherbert1348793sherbert
taber73825823ta_ber_
tabers84621573ta_bers
tablet84227643table_t
talent6323323tal_ent
taler56034863tal_er_
talers64628143tal_ers
talker103916223talker_
talkers113513213talkers
taller63721963taller_
tallest7317093tallest
thaler94613103thal_er_
thalers106212263thal_ers
valet84337873val_e_t
valuer93911443valuer_
valuers10328943valuers
waler84229263wal_er_
walers94824463wal_ers
walker133913993walker_
walkers143411473walkers
wallet93327093walle_t
whaler124611973whal_er_
whalers13529703whal_ers
yabber136111833yabber_
yabbers14389353yabbers

Search took 10 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.1401276364.3
2DLD Change Limit1340272479.12314691.1
3Display Results2472470.0962572.9
 (SQL Overall)1786912479.35919093.0
 
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.