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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
hasping13441490(None) 
gasping113714361gasping
happing153817231happing
harping134118381harping
hashing145020161hashing
hasting114725191hasting
rasping104316251rasping
amping114317572_amping
aping87327232_a_ping
ashing107824092_ashing
asking116017232_asking
bashing135422582bashing
basing95427662bas_ing
basking144718612basking
basting104227202basting
camping143118972camping
capping143819672capping
carping123521082carping
cashing135022552cashing
casing94829102cas_ing
casking144317352casking
casting104628342casting
champing183610932champing
chapping183710722chapping
chasing133715892chas_ing
clasping133310262clasping
damping133414002damping
dapping133714792dapping
dashing125917892dashing
easing74926462eas_ing
easting84924302easting
fashing144918792fashing
fasting114522832fasting
gaping105618922ga_ping
gapping134214782gapping
gashing125119232gashing
gasking134415912gasking
gassing94216332gassing
gasting95022762gasting
gawping14418462gawping
grasping12348832grasping
hacking173720612hacking
hading113922942ha_ding
haeing104118922ha_eing
hafting144014172hafting
hagging133114682hagging
hailing113820692hailing
haling104229782ha_ling
haloing113814132haloing
halting114419072halting
halving143511542halving
hamming153014092hamming
handing123518892handing
hanging123518702hanging
hanking154619102hanking
hanting114124482hanting
haring104233002ha_ring
harking154120942harking
harming133717932harming
harpin113614382harpin_
harpings14379772harpings
harpins123615702harpins
hassling1236802hassling
hating104929712ha_ting
hatpin112610612hatpin_
hatpins123410642hatpins
hatting113920232hatting
hauling113714432hauling
having134220372ha_ving
hawing134322352ha_wing
hawking183711422hawking
haying134420612ha_ying
hazing194218552ha_zing
heaping133015852heaping
helping133512222helping
hipping153915102hipping
hissing114213142hissing
histing113720372histing
hooping133615702hooping
hoping123719742h_oping
hopping154115272hopping
hosing103421102hos_ing
hosting114318382hosting
humping153213072humping
hushing144514472hushing
husking154312052husking
hyping15408482h_yping
japing165013572ja_ping
jauping17307192jauping
lamping123116002lamping
lapping124117022lapping
lapsing103511162lapsing
lashing114422892lashing
lasing74727982las_ing
lasting84725242lasting
lisping103412752lisping
mapping143413992mapping
mashing134422242mashing
masking145116612masking
massing104318022massing
masting104325822masting
napping123514182napping
palping124112872palping
pashing135120512pashing
passing104318422passing
pasting103826552pasting
phasing133211672phas_ing
ramping123316872ramping
raping94829852ra_ping
rapping123619102rapping
rasing74330832ras_ing
raspings11337852raspings
sapping123519312sapping
sashing114621472sashing
sassing84615552sassing
shaping133116182sha_ping
sharping143011372sharping
tamping122815812tamping
taping94222392ta_ping
tapping123317132tapping
tasking124616322tasking
tasting84624212tasting
vamping152810232vamping
wapping153514602wapping
warping133715182warping
washing145119282washing
wasting114422842wasting
whapping19317112whapping
wisping133711942wisping
yapping153412612yapping
yauping13357242yauping
yawping16357332yawping
zapping213211472zapping

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.373479064.3
2DLD Change Limit1076711333.25033129.5
3Display Results1331330.0502660.0
 (SQL Overall)1786911333.67348649.9
 
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.