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

185 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
humvees153468(None) 
humvee1439201humvee_
cuvees1139372cu_vees
humates122813192humates
humbles143215802humbles
hummers143813062hummers
humpers142713522humpers
humuses1237592humuses
bumbles134016843bumbles
bummers133712443bummers
bumpers133912053bumpers
bungees104513103bungees
burgees104915893burgees
chutnees1343963chutnees
corvees124613793corvees
culvers12329833culvers
cumbers134515413cumbers
cummers133713483cummers
curves114619283curv_es
curvets12399913curvets
cuvee10316143cu_vee_
dummies123012133dummies
dumpers123412663dumpers
duvets1039223du_vets
emcees1037813_emcees
fumbles143514413fumbles
fumers113613383fum_ers
fumes105224703fum__es
fumets114311813fum_ets
fusees95416403fu_sees
fuzees184910753fu_zees
gumless10228273gumless
gummers123712203gummers
gumtrees1143883gumtrees
gumweed1433943gumweed
gumweeds1542383gumweeds
hackees165014103hackees
hadjees18356383hadjees
halvers133311423halvers
halves124717093halv_es
hamates122917683hamates
hames106138703ham__es
hamlets123211403hamlets
hammers144216063hammers
hampers143616953hampers
havens124514043h_avens
havers124721483h_avers
haves116034873h_av_es
heavens13439303heavens
heavers133717193heavers
heaves124120303heav_es
heavies132713873heavies
helves124316063helv_es
hemes105031083hem__es
hemmers143310843hemmers
hirees95117293h_irees
hives116925513h_iv_es
homages131011583homages
hombres14369873hombres
homers114821973hom_ers
homes106938813hom__es
homeys145012873hom_eys
homies114524723hom_ies
homines123518643homines
hoovers134312703hoovers
hooves124815483hoov_es
hovels125413333h_ovels
hovers124320253h_overs
hubbies143211563hubbies
huckles163612623huckles
huddles123712573huddles
hueless1058823hueless
hues75235233hu___es
huggers124211593huggers
hullers103616263hullers
hulloes104113923hulloes
humane112812173humane_
humaner12257663humaner
humanest1348123humanest
humans112312433hum_ans
humate113214443humate_
humble133615053humble_
humbled153711813humbled
humbler143411943humbler
humblers15379803humblers
humblest15288283humblest
humbugs1534243humbugs
humeri1138523hum_eri
humerus1236913humerus
humidex2043283humidex
humidexes2241973humidexes
hummed144812673hum_med
hummer133615273hum_mer
hummus1336243hum_mus
hummuses1544453hummuses
humored1336723humored
humors11129633hum_ors
humours1286433humours
humped144015243hum_ped
humper134115883hum_per
humphed1835423humphed
humphs16528163hum_phs
humpier143110723humpier
humpiest1538963humpiest
humpless15226333humpless
humps126322803hum__ps
hums96831423hum___s
humus106215073hum__us
hunches153913463hunches
hungers114013303hungers
hunkers143314333hunkers
hunkeys17386193hunkeys
hunkies143214503hunkies
hunters103915733hunters
hurdies114015663hurdies
hurdles113613373hurdles
hurlers103714323hurlers
hurleys13407333hurleys
hurlies103315333hurlies
hurries103919653hurries
hurters103413643hurters
hurtles103913753hurtles
hushes124718593hu_shes
huskers143510043huskers
huskies143212083huskies
hussies103213293hussies
hustles103414173hustles
hutches153613523hutches
hymens1437993hym_ens
jayvees2052923jayvees
jumbles183013323jumbles
jumpers18399843jumpers
kummels15234793kummels
kumyses1633143kumyses
levees93714523_levees
lumbers113815913lumbers
lumens85013973lum_ens
lumpens11298263lumpens
lumpers113514483lumpers
lungees84412143lungees
mammees104411143mammees
muggees11338883muggees
mumbles133014433mumbles
mummers103712843mummers
mummies103812843mummies
mumpers133311373mumpers
mustees94614923mustees
numbers113711243numbers
numbles113814273numbles
outsees72616433outsees
outvies102214243outvies
pugrees10218523pugrees
pumices1338273pumices
pummels13236543pummels
pumpers133113673pumpers
purees84721683pu_rees
purveys15615903purveys
puttees93612913puttees
quavers19309013quavers
quivers19298753quivers
ramees84620893ram_ees
rumbles114018393rumbles
rumens83611813rum_ens
rummers113513653rummers
rummies113212793rummies
rumples113313133rumples
rupees8312573ru_pees
rushees103311953rushees
subvenes1339633subvenes
sumless92611123sumless
summers113616503summers
surveys13357573surveys
suttees74114063suttees
thuggees1343123thuggees
thumpers15365713thumpers
tumbles113816023tumbles
tummies113012033tummies
turves94212693turv_es
tutees6514553tu_tees
umbels104510593_umbels
umbers104215213_umbers
umbles103817493_umbles
uveas84912283_u_veas
vees75439433___vees
yummies14359533yummies

Search took 7 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 Limit1340271856.54620474.6
3Display Results1851850.0802312.5
 (SQL Overall)1786911856.76626410.1
 
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.