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 “haulers” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
haulers10401244(None) 
hailers104017261hailers
halers94926911ha_lers
hauler95015121hauler_
hauliers1176711hauliers
maulers94213301maulers
augers73818702_augers
bailers94221352bailers
balers85626932ba_lers
ballers94421012ballers
bawlers124412732bawlers
cablers114416712cablers
callers94221962callers
caules85927252caule_s
caulkers14375652caulkers
causers94014792causers
chaufers16347302chaufers
daubers104610422daubers
fablers124812612fablers
fallers103917992fallers
gaolers83511562gaolers
gaugers94211712gaugers
hackers164619042hackers
hacklers173710302hacklers
hafters134614332hafters
hagglers13326622hagglers
hailer94720342hailer_
haler85033522ha_ler_
haleru94212072ha_leru
hales85449842ha_le_s
hallels103310132hallels
halters104619802halters
halvers133311422halvers
hamlets123211402hamlets
hammers144216062hammers
hampers143616952hampers
handers114224332handers
handlers124014142handlers
hangers113120812hangers
hankers144218132hankers
haoles94919802haole_s
hapless123311332hapless
harmers124116592harmers
harpers124916202harpers
haslets102510862haslets
haters94930402ha_ters
hatless103813442hatless
hatters104221522hatters
hauberk1633462hauberk
hauberks1742992hauberks
hauled104415212haule_d
haulier1059942haulier_
haulms11558502haul_ms
hauls86123732haul__s
haunters11329542haunters
hausens1077632hausens
hauteurs1133732hauteurs
havers124721482ha_vers
hawkers174210332hawkers
hawsers13409482hawsers
hayers124415942ha_yers
hazers184615952ha_zers
healers104319462healers
heelers103815622heelers
hellers103619832hellers
hillers103718732hillers
hollers103818232hollers
housers104717812housers
howlers133312352howlers
hullers103616262hullers
hurlers103714322hurlers
inhaulers1263242inhaulers
jailers144114042jailers
ladlers84613572ladlers
lauders84012892lauders
mailers94420332mailers
mauler84416712mauler_
nailers73215892nailers
paupers114311072paupers
pausers94113222pausers
pulers83820282_pulers
railers74420662railers
rulers64317092_rulers
sailers73822322sailers
saucers93712132saucers
saugers83914052saugers
tailers73720182tailers
talers64628142ta_lers
thalers106212262tha_lers
valuers10328942valuers
vaulters11206172vaulters
wailers103916802wailers
walers94824462wa_lers
whalers13529702wha_lers
yaupers12337662yaupers

Search took 4 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 Filter1786911076710.390458182.1
2DLD Change Limit107671952.89037256.4
3Display Results95950.0303166.7
 (SQL Overall)178691953.31053985.2
 
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.