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

152 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
hauberk163346(None) 
hauberks1742991hauberks
dauber94112012dauber_
daubers104610422daubers
daubery13396212daubery
halberd1336052halberd
halbert12314502halbert
hauler95015122hauler_
haulers104012442haulers
amber94523213_amber_
ambers104519583_ambers
ambery133811133_ambery
auberge1045633_auberge
auburn836213_auburn
auger64922473_auger_
augers73818703_augers
barber104419323barber_
barbers114317503barbers
baubee103215993baube_e
baubees11348713baubees
berk105929843___berk
caber95126833ca_ber_
cabers105023923ca_bers
camber124418483camber_
cambers134017443cambers
causer84117783causer_
causers94014793causers
cautery12349593cautery
chamber164011063chamber_
chambers173410623chambers
chaufer15347943chaufer_
chaufers16347303chaufers
cuber95222533_cuber_
cubers105318353_cubers
dabber114816963dabber_
dabbers123813213dabbers
daube85015303daube__
daubed104611783daube_d
daubes94913703daube_s
daubier1037103daubier_
daubry12445483daub_ry
fabber134814113fabber_
gabber114916603gabber_
gabbers124612833gabbers
gaudery1234743gaudery
gauger84714853gauger_
gaugers94211713gaugers
hacek145411843ha_ce_k
hacker154822693hacker_
hackers164619043hackers
hafter124815883hafter_
hafters134614333hafters
hagberry1742903hagberry
hagborn1344953hagborn
hailer94720343hailer_
hailers104017263hailers
halberds1435183halberds
halberts1335973halberts
haler85033523ha_ler_
halers94926913ha_lers
haleru94212073ha_leru
halfbeak2042373halfbeak
halter94420883halter_
haltere103614703haltere
halters104619803halters
halvers133311423halvers
hamburg1544123hamburg
hammer138120033hammer_
hammers144216063hammers
hamper134518653hamper_
hampers143616953hampers
hander104526433hander_
handers114224333handers
hanger104023253hanger_
hangers113120813hangers
hanker134622093hanker_
hankers144218133hankers
harbor11410723harbor_
harbors12412413harbors
harder105022403harder_
hark115237393ha___rk
harmer114719553harmer_
harmers124116593harmers
harper115018403harper_
harpers124916203harpers
hater85034753ha_ter_
haters94930403ha_ters
hatter94724873hatter_
hatters104221523hatters
hauled104415213haule_d
haulier1059943haulier_
hauliers1176713hauliers
haunter103111153haunter_
haunters11329543haunters
hausen9610383hause_n
hausens1077633hausens
haute89521613haute__
hauteur1033893hauteur
hauteurs1133733hauteurs
haver115124463ha_ver_
havers124721483ha_vers
hawker164812663hawker_
hawkers174210333hawkers
hawser125910843hawser_
hawsers13409483hawsers
hayer114620243ha_yer_
hayers124415943ha_yers
hayfork2043763hayfork
hazer174820233ha_zer_
hazers184615953ha_zers
hazier184712403hazier_
hobber134114633hobber_
hobbers143512343hobbers
houser95322283houser_
housers104717813housers
huger94914873h_uger_
humeri1138523h_umeri
jabber173713643jabber_
jabbers183610583jabbers
lamber104418493lamber_
lambers113817113lambers
lambert113617113lambert
lauder73815013lauder_
lauders84012893lauders
mauger93813483mauger_
mauler84416713mauler_
maulers94213303maulers
nabber104913543nabber_
nabbers113710463nabbers
pauper103511943pauper_
paupers114311073paupers
pauser84415963pauser_
pausers94113223pausers
saber75330243sa_ber_
sabers85224733sa_bers
saucer84314103saucer_
saucers93712133saucers
sauger74316253sauger_
saugers83914053saugers
shagbark1843113shagbark
suber74924503_suber_
subers85722643_subers
taber73825823ta_ber_
tabers84621573ta_bers
tanbark1337373tanbark
tauter64318023tauter_
tuber75420683_tuber_
tubers85017033_tubers
yabber136111833yabber_
yabbers14389353yabbers
yauper11368543yauper_
yaupers12337663yaupers

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.436409841.7
2DLD Change Limit1340271526.87619492.0
3Display Results1521520.0463304.3
 (SQL Overall)1786911527.35824285.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.