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

305 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
hauliers117671(None) 
haulers104012441haul_ers
haulier1059941haulier_
caulkers14375652caulkers
dalliers93610612dalliers
hailers104017262hail_ers
halers94926912ha_l_ers
halters104619802ha_lters
halvers133311422ha_lvers
harriers113712432harriers
hauler95015122haul_er_
haulmier1333142haulmier_
haunters11329542haunters
hullers103616262h_ullers
maulers94213302maul_ers
ralliers84010832ralliers
salliers83613342salliers
sauciers1076732sauciers
talliers83711372talliers
vaulters11206172vaulters
alders74218423_a_lders
aliens65619213_a_liens
aliners74717723_a_liners
allies63827673_allie_s
alters64924223_a_lters
appliers1235573appliers
ateliers837883ateliers
augers73818703_au_gers
aulder7511453_aulder_
bailers94221353bail_ers
bailies94120203bailie_s
balers85626933ba_l_ers
balkers134915723ba_lkers
ballers94421013ba_llers
ballies93725743ballie_s
barriers104311883barriers
baulkier1433533baulkier_
bawlers124412733bawl_ers
beliers94617383_beliers
boulders113010033boulders
bouviers1375003bouviers
bulgers105215143_bulgers
buriers94017193_buriers
cablers114416713cabl_ers
cahiers123510673ca_hiers
calibers1238523ca_libers
calipers1249443ca_lipers
calkers134414693ca_lkers
callers94221963ca_llers
callipers1356493callipers
carriers103614203carriers
cashiers13318883cashiers
caules85927253caul_e_s
caulis85320083cauli__s
caulker13456893caulker_
causers94014793cau_sers
cavaliers1455623cavaliers
cavilers1348113cavilers
challies133915643challie_s
charlies133414233charlie_s
chaufers16347303chau_fers
chauffers20253443chauffers
chaunters1455823chaunters
colliers103613583colliers
coulters103614313coulters
couriers103213173couriers
crullers1047303crullers
cullers93418853_cullers
culvers12329833_culvers
dailies84219263dailie_s
dallier84215373dallier_
dallies84023193dallie_s
daubers104610423dau_bers
daubier1037103daubier_
daunders10278473daunders
daunters9329853daunters
dauties83315763dautie_s
earlier72612743earlier_
fablers124812613fabl_ers
fallers103917993fa_llers
falters103916473fa_lters
fanciers13358083fanciers
farriers113610743farriers
faultier1135283faultier_
fliers94417193__fliers
fullers103817373_fullers
gallies84122713gallie_s
gambiers13337073gambiers
gaolers83511563gaol_ers
gasaliers1044513gasaliers
gaseliers1044923gaseliers
gasoliers1044203gasoliers
gaudier938453gaudier_
gaudies9311973gaudie_s
gauffers1563833gauffers
gaugers94211713gau_gers
gauleiters1142103gauleiters
gauzier1735633gauzier_
ghoulies1235393ghoulie_s
gulpers10299013_gulpers
hackers164619043ha_ckers
hackies163418243hackie_s
hacklers173710303hacklers
hacklier1737133hacklier_
hafters134614333ha_fters
hagglers13326623hagglers
hagriders1443553hagriders
hailer94720343hail_er_
hairier103111053hairier_
hairs86225173ha__i_rs
halberd1336053ha_lberd
halberds1435183ha_lberds
halbert12314503ha_lbert
halberts1335973ha_lberts
haler85033523ha_l_er_
haleru94212073ha_l_eru
hales85449843ha_l_e_s
halides113416663ha_lides
halids104016133ha_li_ds
halites103221193ha_lites
halitus10339963ha_litus
hallels103310133ha_llels
halliard12125963halliard
halliards13104933halliards
halloes104021523halloe_s
hallowers15137723hallowers
haloes94623863ha_loe_s
halter94420883ha_lter_
haltere103614713ha_ltere
halteres113414603ha_lteres
halves124717093ha_lve_s
hamlets123211403haml_ets
hammers144216063ha_mmers
hammier143510653hammier_
hampers143616953ha_mpers
hamsters13710423hamsters
hanapers1346963hanapers
handers114224333ha_nders
handier113817443handier_
handlers124014143handlers
hangers113120813ha_ngers
hankers144218133ha_nkers
hankies143617763hankie_s
haoles94919803haol_e_s
hapless123311333hapl_ess
haplites1339993haplites
happier143312043happier_
hardier114721543hardier_
hardies114923233hardie_s
harmers124116593ha_rmers
harpers124916203ha_rpers
harpies123818323harpie_s
harrier104417763harrier_
harries103525503harrie_s
haslets102510863hasl_ets
hastier103916623hastier_
hatchers163113173hatchers
haters94930403ha__ters
hatless103813443hatl_ess
hatters104221523ha_tters
hauberk1633463hau_berk
hauberks1742993hau_berks
haulages1236623haulages
hauled104415213haul_e_d
hauling113714433hauli_ng
haulmiest1443813haulmiest
haulms11558503haul__ms
hauls86123733haul___s
haulyard1583223haulyard
haulyards1682833haulyards
haunter103111153haunter_
hausens1077633hau_sens
hauteurs1133733hauteurs
havers124721483ha__vers
haviors1347383ha_viors
hawkers174210333ha_wkers
hawkies173311243hawkie_s
hawsers13409483ha_wsers
hayers124415943ha__yers
haywires1744043haywires
hazers184615953ha__zers
hazier184712403ha_zier_
headliners14144333headliners
healers104319463heal_ers
heelers103815633heel_ers
hellers103619833h_ellers
helpers123311853h_elpers
hillers103718733h_illers
hillier103413963hillier_
holders113715903h_olders
holier94921623h_olier_
holies94630033h_olie_s
hollers103818233h_ollers
hollies103420813hollie_s
hosiers104212643h_osiers
hoteliers1245803hoteliers
hounders123111713hounders
hourlies1138343hourlie_s
housers104717823hou_sers
howlers133312353howl_ers
huggers124211593h_uggers
hulkier14328973h_ulkier_
huller93919103h_uller_
hummers143813063h_ummers
humpers142713523h_umpers
hungers114013303h_ungers
hunkers143314333h_unkers
hunters103915733h_unters
hurlers103714323h_urlers
hurlies103315333hurlie_s
hurriers11358893hurriers
hurters103413643h_urters
huskers143510043h_uskers
inhaulers1263243inhaul_ers
inliers73110743_inliers
jailers144114043jail_ers
jolliers15357433jolliers
kauries113613193kaurie_s
krullers1234133krullers
ladlers84613573ladl_ers
lanciers10308543lanciers
lauders84012893lau_ders
laughers1235923laughers
launders9358743launders
lavaliers1254283lavaliers
liers55130403___liers
lullers73213353_lullers
mailers94420333mail_ers
manlier92414023manlier_
marlier92614773marlier_
marriers103312473marriers
mauler84416713maul_er_
maunders11348343maunders
milliers102611903milliers
moulders11348343moulders
moulters103510783moulters
mullers93217303_mullers
nailers73215893nail_ers
outliers82610673outliers
palier85023563pa_lier_
pallier94417163pallier_
palmers113513623pa_lmers
palters94021683pa_lters
paniers94717333pa_niers
panniers10488853panniers
parriers103612903parriers
partiers103514243partiers
paulins9312613pauli_ns
paupers114311073pau_pers
pausers94113223pau_sers
pliers84715153__pliers
poulters103911053poulters
pulers83820283_pul_ers
pullers93618483_pullers
pulpers114612283_pulpers
pulsers94213153_pulsers
railers74420663rail_ers
rallier73816273rallier_
rallies73823343rallie_s
rapiers95012873ra_piers
reliers75519213_reliers
repliers103710163repliers
rulers64317093_rul_ers
rulier65016353_rulier_
sailers73822323sail_ers
sallier73320423sallier_
sallies73227813sallie_s
salters73622253sa_lters
saltiers83411953saltiers
saluters8319863saluters
salvers103916003sa_lvers
saucers93712133sau_cers
saucier9810283saucier_
saugers83914053sau_gers
saunters82911753saunters
sauries72821623saurie_s
sculkers14306933sculkers
scullers103510483scullers
shalier103116423sha_lier_
shoulders1334233shoulders
skulkers11334923skulkers
studiers9236623studiers
sulkers113613343_sulkers
tailers73720183tail_ers
talers64628143ta_l_ers
talkers113513213ta_lkers
tallier72817213tallier_
tallies73624603tallie_s
tarriers83411713tarriers
tarsiers8298533tarsiers
taunters8259273taunters
thalers106212263tha_l_ers
ulcers839383__ulcers
valuers10328943va_luers
variers103712663va_riers
vaulter10257713vaulter_
vaultier1144293vaultier_
vaunters11327753vaunters
wailers103916803wail_ers
walers94824463wa_l_ers
walies95324523wa_lie_s
walkers143411473wa_lkers
wallies103320743wallie_s
whalers13529703wha_l_ers
yaupers12337663yau_pers

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623057.11020557.2
3Display Results3053050.1232479.7
 (SQL Overall)1786913057.65623340.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.