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

243 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
yawpings1725358(None) 
yawping16357331yawping_
awnings11406712_awnings
campings154010202campings
cappings15369492cappings
carpings133812382carpings
dampings14377522dampings
gawping14418462gawping_
harpings14379772harpings
hawkings19336132hawkings
lapwings14274972lapwings
lawings113611472law_ings
mappings15296412mappings
raspings11337852raspings
tappings13267712tappings
yapping153412612yapping_
yauping13357242yauping_
yawing134215612yaw_ing_
yawling14369182yawling_
yawning14378342yawning_
ablings1038743_ablings
actings104512463_actings
ageings9437693_ageings
agings86312673_a_gings
airings83913833_airings
alpines94016193_alpines
amping114317573_amping_
antings85015583_antings
aping87327233_a_ping_
armings103811493_armings
askings12519173_askings
audings9289393_audings
aweing103911253_aweing_
awing96827323_aw_ing_
awning105013393_awning_
backings174012213backings
baggings13307523baggings
bakings144312013ba_kings
bankings15489403bankings
bashings144311243bashings
bastings114214693bastings
battings114010573battings
bawling133813863bawling_
bowings133612003bow_ings
bowlings14408753bowlings
calkings15289223calkings
callings113613833callings
camping143118973camping_
campongs15356123campongs
cannings113710333cannings
capping143819673capping_
cardings123812623cardings
carlings114015853carlings
carping123521083carping_
carvings143810203carvings
casings104013513ca_sings
castings113614053castings
catlings113712043catlings
cavings134712543ca_vings
cawing124322613caw_ing_
copings124111843_copings
cowlings14359773cowlings
cuppings15336053cuppings
damping133414003damping_
dapping133714793dapping_
darings93713643da_rings
darlings103710383darlings
darnings10378553darnings
dawing114819823daw_ing_
dawning124111013dawning_
dawting123610673dawting_
dopings11408783_dopings
drawings13386273draw_ings
dumpings14295763dumpings
eanlings9128463eanlings
earings84517703ea_rings
earnings9419323earnings
earrings9299623earrings
eastings93412953eastings
eatings84616433ea_tings
facings134511263fa_cings
fadings12469303fa_dings
failings123811013failings
fairings12388193fairings
farmings14298213farmings
fastings124011943fastings
fatlings12359303fatlings
fawning14409133fawning_
fowlings15377243fowlings
gamings114610913ga_mings
gaping105618923ga_ping_
gapping134214783gapping_
gaskings14427473gaskings
gasping113714363gasping_
gassings10438403gassings
gatings95212823ga_tings
gawking16398823gawking_
gaywings1633193gaywings
gnawings13263773gnaw_ings
hangings13258583hangings
happing153817233happing_
harping134118383harping_
harpins123615703harpin_s
hasping134414903hasping_
hatpins123410643hatpin_s
hawing134322353haw_ing_
hawking183711423hawking_
hayings14379393ha_yings
hazings20378343ha_zings
helpings14255653helpings
hoppings16306523hoppings
impings12348553_impings
japing165013573ja_ping_
jauping17307193jauping_
jawing174414963jaw_ing_
jawlines18126363jawlines
kampongs17293033kampongs
kartings13418523kartings
keepings15345943keepings
lacings105013653la_cings
ladings93814133la_dings
laggings11298403laggings
lakings124713503la_kings
lamping123116003lamping_
landings103110073landings
lapins84520683la_pin_s
lapping124117023lapping_
lapwing13308263lapwing_
lashings124412253lashings
lastings94214423lastings
lathings12469853lathings
lawines103313563law_ines
lawing104625283law_ing_
lippings13296093lippings
lowings113710073low_ings
mailings113011923mailings
makings145413153ma_kings
mallings113413093mallings
mapping143413993mapping_
markings153410233markings
marlings113713483marlings
maskings15448743maskings
matings104516203ma_tings
mattings11369673mattings
mawing124020803maw_ing_
mayings134410503ma_yings
mowings13328483mow_ings
napping123514183napping_
packings174310063packings
paddings13297003paddings
pagings114411063pa_gings
pairings11398313pairings
palings103915823pa_lings
palping124112873palping_
pargings123410163pargings
parings104219213pa_rings
parkings153610673parkings
partings113513733partings
passings11409873passings
pavings134011633pa_vings
pawing124519553paw_ing_
pawning134711413pawning_
pings85830883___pings
pipings12338253_pipings
racings105015123ra_cings
railings93412153railings
raisings9338443raisings
ramping123316873ramping_
rankings13389163rankings
rapines95120863ra_pines
raping94829853ra_ping_
rapping123619103rapping_
rasping104316253rasping_
ratings84217403ra_tings
ravings114614493ra_vings
rawins95617623raw_in_s
rowings113710363row_ings
sackings15389633sackings
sacrings11278923sacrings
sailings93513253sailings
salpinges1244523salpinges
saltings92811253saltings
samplings1435553samplings
saplings11269803saplings
sapping123519313sapping_
savings114412953sa_vings
sawing104323813saw_ing_
sayings113610833sa_yings
sewings11369173sew_ings
swings104714453_sw_ings
tailings93211673tailings
takings124512563ta_kings
talkings13358403talkings
tamping122815813tamping_
tannings9268633tannings
taping94222393ta_ping_
tapping123317133tapping_
tattings9408823tattings
tawing104521553taw_ing_
tawpies12309873tawpi_es
tawsing1138673tawsing_
toppings13286423toppings
trappings14265753trappings
uppings12257123_uppings
vamping152810233vamping_
waddings14356463waddings
waitings123413743waitings
walkings16327313walkings
wapping153514603wapping_
warnings12358453warnings
warping133715183warping_
washings15419273washings
wawling143810963wawling_
waxings18366453wa_xings
waxwings2232953waxwings
weepings14346483weepings
wings95727243__w_ings
wrappings17253713wrappings
wrings104012973__wrings
yachtings1842663yachtings
yacking174315683yacking_
yaffing17337823yaffing_
yakking14376423yakking_
yangs95618693ya___ngs
yanking154512463yanking_
yapons114411773ya_pon_s
yappingly2043793yappingly
yarding123413143yarding_
yarning113512953yarning_
yaupons12345683yaupon_s
yawningly1943483yawningly
yawns114213273yaw__n_s
yawpers15346853yawp_ers
yawps13628793yawp___s
yealings12257693yealings
yeanlings1393693yeanlings
yearlings1384193yearlings
yearnings1393543yearnings
yelping13317873yelping_
yipping152710683yipping_
yowing133715543yow_ing_
yowling143610223yowling_
zapping213211473zapping_

Search took 9 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 Filter1786911461620.220812231.8
2DLD Change Limit1461622437.98318309.2
3Display Results2432430.0962531.3
 (SQL Overall)1786912438.29921531.6
 
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.