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

202 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
hulloos10401007(None) 
halloos103716741halloos
holloos104013581holloos
hulloas103911911hulloas
hulloes104113921hulloes
hulloo94511731hulloo_
hullos94916291hull_os
bullous9311662bullous
halloas104318462halloas
halloes104021522halloes
halloo95118972halloo_
hallos95425102hall_os
hallows134417392hallows
helloes103717462helloes
hellos95321682hell_os
hilloas104413552hilloas
hilloes103815962hilloes
hillos94618892hill_os
holloas103814942holloas
holloes103818192holloes
holloo94415252holloo_
hollos95320632holl_os
hollows134412332hollows
hullers103616262hullers
hullo84417452hull_o_
hulloa95011182hull_oa
hulloed11369792hulloed
hullooed12135092hullooed
hulls84923562hull__s
allods73615083_allods
allots64019173_allots
allows94517683_allows
alloys94014563_alloys
ballons93916963ballons
balloon93711433balloon
balloons103110523balloons
ballots94116033ballots
bellows124313303bellows
billons93013363billons
billows123611293billows
bugloss1035893bugloss
bulbous1138293bulbous
bulldog1174253bulldog
bulldogs1274243bulldogs
bullets93516393bullets
bullies94121893bullies
bullion91911033bullion
bullions101710043bullions
bullnose1044553bullnose
bullock1537193bullock
bullocks1636293bullocks
bulls75629573bull__s
burgoos1037123burgoos
callous93516603callous
cellos84517803cell_os
collops112611753collops
cuckoos1585123cuckoos
cullays12347703cullays
cullers93418853cullers
cullets94015613cullets
cullies94419963cullies
cullion91910233cullion
cullions10219223cullions
cullis84115993cull_is
culls75425813cull__s
dollops10287963dollops
duellos845763duellos
dulls64523743dull__s
duologs935363duologs
fallows133713973fallows
felloes104114383felloes
fellows134212433fellows
fillos94415083fill_os
follows13409923follows
fullams1236553fullams
fullers103817373fullers
fulls84623523full__s
fulvous1334543fulvous
gallons83015953gallons
galloon82910643galloon
galloons9289703galloons
galloot82814223galloot
galloots9268963galloots
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
gullets84013713gullets
gulleys11438523gulleys
gullies84717313gullies
gulls65222983gull__s
hallahs133912463hallahs
hallels103310133hallels
hallo85127553hall_o_
halloa94918123hall_oa
halloed113314913halloed
hallooed12168773hallooed
hallot95426783hall_ot
halloth134111253halloth
hallow124818323hall_ow
halls85633783hall__s
haloes94623863h_aloes
halons95720713h_alons
halos85230253h_al_os
harlots103413293harlots
helios94816633h_elios
hellbox1944983hellbox
hellers103619833hellers
hellion10311133hellion
hellions11310023hellions
hello86522983hell_o_
helloed113512423helloed
hells85032043hell__s
helos84928063h_el_os
helots95217703h_elots
hillers103718733hillers
hillo84721653hill_o_
hilloa94713033hill_oa
hillock1646693hillock
hillocks1736063hillocks
hilloed113211293hilloed
hills85431353hill__s
hilltop1244783hilltop
hilltops1344933hilltops
hollas94616903holl_as
hollers103818233hollers
hollies103420813hollies
hollo84822163holl_o_
holloa94914823holl_oa
holloed113812753holloed
hollooed12146493hollooed
hollow124212663holl_ow
hoodoos11109293hoodoos
hoopoos1298543hoopoos
hueless1058823hueless
hugeous1137133hugeous
hulas84920883hu_l_as
hulks125715483hu_l_ks
hull75428783hull___
hulled103920013hull_ed
huller93919103hull_er
hulling113619013hulling
hulloaed12105803hulloaed
hulloing12146703hulloing
hullooing1383993hullooing
humors11129633hu_mors
hurlers103714323hurlers
hurleys13407333hurleys
hurlies103315333hurlies
hurls86522713hurl__s
igloos738033_igloos
jellos134714283jell_os
lollops9227443lollops
loos49051123___loos
lullers73213353lullers
lulls54119653lull__s
mallows123714323mallows
mellows123812233mellows
mullahs12388733mullahs
mullas84215933mull_as
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulleys12299203mulleys
mullion91911173mullion
mullions101910353mullions
mullock1535713mullock
mullocks1645033mullocks
mulls75124153mull__s
nullahs10316993nullahs
nulls55019983null__s
outlook1138023outlook
outlooks1236793outlooks
pallors9314363pallors
phyllos1535583phyll_os
pillows122610123pillows
pullers93618483pullers
pullets94015163pullets
pulleys12399143pulleys
pullout9310593pullout
pullouts1045223pullouts
pulls74425053pull__s
pullups1134233pullups
pulpous1177013pulpous
putlogs1065083putlogs
sallows103915553sallows
shalloon1145683shalloon
shalloons1245223shalloons
shallops13288323shallops
shallots11319503shallots
shallows14388863shallows
sublots92410913sublots
sullies74122233sullies
tallols73311363tallols
tallows103313743tallows
thallous1136523thallous
tulles63218893tull_es
unloose797863_unloose
villous102810023villous
wallops123410413wallops
wallows133613533wallows
willows13299753willows
yellows13329603yellows

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.403443402.0
2DLD Change Limit1340272025.80023108.1
3Display Results2022020.0762657.9
 (SQL Overall)1786912026.27928458.5
 
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.