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

174 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
hooplas123919(None) 
hoopla1147631hoopla_
whooplas1644001whooplas
hollas94616902h_ollas
homoplasy1944872homoplasy
hookas135312492hoo_kas
hoopers123616482hoopers
hoopless13279252hoopless
hoopoes121212482hoopoes
hoopoos1298542hoopoos
hoops105621072hoop__s
hopples142810712hopples
moolas83615592moo_las
whoopla1542632whoopla_
anopias92412473anopias
axoplasm1943733axoplasm
bioplasm1444873bioplasm
bolas74733763_bo_las
boodles103416043boodles
boylas113011723_boylas
cholas114817993cho_las
chollas123811353chollas
coalas87418963_coalas
colas75436773_co_las
compas125817063comp_as
cools75632633coo_l_s
coopers114019483coopers
coops96229643coop__s
coopts105814583coop_ts
copals105018943_copals
coppras13327833coppras
copras103517153_copras
copulas113811563copulas
corollas1039203corollas
couples115317053couples
cowpeas1437273cowpeas
cupolas11277753cupolas
dhooras1135943dhoo_ras
doblas93812293_doblas
doodles93614163doodles
dopas85019063_dop_as
doulas75114993_doulas
fools86824203foo_l_s
footles103715713footles
foozles19329543foozles
goops86620963goop__s
goorals838703goorals
halalas104214083halalas
haoles94919803hao_les
hawalas13348353hawalas
hexaplas2043523hexaplas
hirples12149643hirples
hobbles143313783hobbles
holds94623243h_o_lds
holes84748653h_o_les
holks124720563h_o_lks
holla84918493h_olla_
holloas103814943holloas
hollos95320633h_ollos
holms105117803h_o_lms
hols76946293h_o_l_s
holts85627913h_o_lts
homopolar1653693homopolar
hondas10313353h_ondas
hondles113614523hondles
hooches153812523hooches
hoodies113419833hoodies
hoodless12289733hoodless
hoodlum1343813hoodlum
hoodlums1443273hoodlums
hoodoos11109293hoodoos
hoods95124083hoo__ds
hooeys125512313hoo_eys
hoofers134513323hoofers
hoofless14258013hoofless
hoofs115721043hoo__fs
hooka125513903hoo_ka_
hookah16488243hoo_kah
hookahs17446653hookahs
hookers144916513hookers
hookeys17448953hookeys
hookies144017443hookies
hookless151238363hookless
hooklet142510813hooklet
hooklets15217203hooklets
hooks125027123hoo__ks
hookups1633263hookups
hoolie93217773hoo_lie
hooly115022223hoo_l_y
hoop96129983hoop___
hooped125518183hoop_ed
hooper114518313hoop_er
hooping133615703hooping
hooplike1736763hooplike
hoopoe11911233hoop_oe
hoopoo1198753hoop_oo
hoorah124411113hoo_rah
hoorahs13399603hoorahs
hooray123011373hoo_ray
hoorays13418373hoorays
hooters104520463hooters
hoots84830243hoo__ts
hoovers134312703hoovers
hooves124815483hoo_ves
hopers114222973h_opers
hopes105835643h_op_es
hoppers143115143hoppers
hopple132910483hoppl_e
hoppled15338083hoppled
hops97942633h_op__s
horas86333093h_o_ras
hosels94218603hosel_s
hostas94515823h_ostas
hotels94515503hotel_s
hovels125413333hovel_s
howls116219223h_owl_s
hoyas115016163h_o_yas
hoyles12315013h_oyles
hulas84920883h__ulas
hylas114815903h__ylas
koalas104011663_koalas
kolas94822233_ko_las
koppas14407603_koppas
loofas9429833loo_fas
loopers93914033loopers
loops75723963loop__s
molas75132093_mo_las
moola75117033moo_la_
moolah11409193moo_lah
moolahs12347383moo_lahs
mools76027173moo_l_s
morulas959703morulas
myopias14308143myopias
neoplasm1245293neoplasm
nonplay1246683nonplay
nonplays1344893nonplays
nonplus936183nonplus
noodles83513193noodles
nopals84914023_nopals
ollas54218283__ollas
oodles73517183_oodles
oops65232673_oop__s
opals75718353__opals
peoples11312213peoples
photopias16410123photopias
photoplay1954753photoplay
photoplays2054713photoplays
poodles103013513poodles
pools74427703poo_l_s
poops94422413poop__s
poplar103611113_poplar
poplars113910333_poplars
poppas93710713_poppas
popples103011873popples
rootles73215633rootles
scopulas1265483scopulas
shools94919003shoo_l_s
tolas54532773_to_las
tonoplast1146893tonoplast
tools55325243too_l_s
tootles72915603tootles
topples113111653topples
torulas759843torulas
utopias9117723utopias
violas93713523vio_las
whoopees16294823whoopees
whoopers16286263whoopers
whoopies16267363whoopies
whoops14487863whoop__s
wools84421463woo_l_s
woops104917523woop__s
woopses1237883woopses
zonulas1637023zonulas
zoogleas1843373zoogleas

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.1561145455.1
2DLD Change Limit1340271747.01619103.1
3Display Results1741740.0602900.0
 (SQL Overall)1786911747.23224708.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.