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

303 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
lapwings1427497(None) 
lapwing13308261lapwing_
lawings113611471la_wings
cappings15369492cappings
gaywings1633192gaywings
lacewings1543302lacewings
lacings105013652la_cings
ladings93814132la_dings
laggings11298402laggings
lakings124713502la_kings
landings103110072landings
lapins84520682lap_in_s
lapping124117022lapping_
lapsing103511162lapsing_
lashings124412252lashings
lastings94214422lastings
lathings12469852lathings
lauwines1145712lauwines
lawines103313562la_wines
lawing104625282la_wing_
lippings13296092lippings
lowings113710072l_owings
mappings15296412mappings
saplings11269802saplings
tappings13267712tappings
waxwings2232952waxwings
yawpings17253582yawpings
ablings1038743_ablings
actings104512463_actings
ageings9437693_ageings
agings86312673_a_gings
airings83913833_airings
alpines94016193alp_ines
antings85015583_antings
aping87327233_ap_ing_
armings103811493_armings
askings12519173_askings
audings9289393_audings
awing96827323_a_wing_
awnings11406713_awnings
backings174012213backings
baggings13307523baggings
bagwigs1432823bagwi_gs
bakings144312013ba_kings
bankings15489403bankings
bashings144311243bashings
bastings114214693bastings
battings114010573battings
batwing13509813batwing_
blackings18316763blackings
bladings12337753bla_dings
blaggings14324463blaggings
blastings12347903blastings
blawing134012753bla_wing_
bowings133612003_bowings
brewings14296693brewings
calkings15289223calkings
callings113613833callings
campings154010203campings
cannings113710333cannings
caplins113515993caplin_s
capping143819673capping_
cardings123812623cardings
carlings114015853carlings
carpings133812383carpings
carvings143810203carvings
casings104013513ca_sings
castings113614053castings
catlings113712043catlings
cavings134712543ca_vings
cawing124322613ca_wing_
claddings1433213claddings
clapping153810603clapping_
clawing133812673cla_wing_
clearwings1651703clearwings
clippings16273753clippings
copings124111843cop_ings
cuppings15336053cuppings
dampings14377523dampings
dapping133714793dapping_
darings93713643da_rings
darlings103710383darlings
darnings10378553darnings
dawing114819823da_wing_
dopings11408783dop_ings
drawings13386273drawings
eanlings9128463eanlings
earings84517703ea_rings
earnings9419323earnings
earrings9299623earrings
earwigs11104413earwi_gs
eastings93412953eastings
eatings84616433ea_tings
elapsing1146713elapsing_
emptings1364813emptings
facings134511263fa_cings
fadings12469303fa_dings
failings123811013failings
fairings12388193fairings
farmings14298213farmings
fastings124011943fastings
fatlings12359303fatlings
flaggings15285183flaggings
flapping16298153flapping_
flashings16316663flashings
flatlings13315823flatlings
flawing143812563fla_wing_
gamings114610913ga_mings
gaping105618923gap_ing_
gapping134214783gapping_
gaskings14427473gaskings
gassings10438403gassings
gatings95212823ga_tings
gawping14418463gawping_
glazings19325753gla_zings
gnawings13263773gnawings
hangings13258583hangings
happing153817233happing_
harpings14379773harpings
hawing134322353ha_wing_
hawkings19336133hawkings
hayings14379393ha_yings
hazings20378343ha_zings
hoppings16306523hoppings
impings12348543imp_ings
japing165013573jap_ing_
jawing174414963ja_wing_
kartings13418523kartings
knowings16234033knowings
lacewing1435843lacewing_
lacing94626233la_cing_
lacking143821543lacking_
lading84227123la_ding_
ladinos8389963la_dinos
ladling92813393ladling_
lagging103316733lagging_
lairing83715343lairing_
laking115027043la_king_
lalling83519623lalling_
lambing123412403lambing_
laminas93615873la_minas
laming94528363la_ming_
lamming123014583lamming_
lamping123116003lamping_
lancing103314123lancing_
landing92819323landing_
lapdogs1134073lap_dogs
lapides103012043lap_ides
lapin75222923lap_in__
lapis76223153lap_i__s
lapises93513463lap_ises
larding92917873larding_
larking123718253larking_
lashing114422893lashing_
lashins103915153lashin_s
lasing74727983la_sing_
lasting84725243lasting_
lathing114315693lathing_
latinas74416463la_tinas
latinos73613803la_tinos
latrines8515003latrines
lattins74115483lattin_s
lauding93211903lauding_
laughings1443483laughings
lauwine1036373lauwin_e
laving104623573la_ving_
lawine93316463la_win_e
lawns85215423la_w_n_s
layerings13235673layerings
laying104525703la_ying_
layins93817653la_yin_s
lazing164821473la_zing_
lazying2046673lazying_
leadings103511233leadings
leanings94010173leanings
leaping103215993leap_ing_
learnings1094313learnings
leasings9379833leasings
leavings12407483leavings
leggings11316193leggings
lemmings13254723lemmings
leptins92412693leptin_s
lickings15298143lickings
likings12539413l_ikings
lings67135773l___ings
linings84313073l_inings
lipins85016883lip_in_s
lipping123016073lipping_
listings93310043listings
livings11408923l_ivings
loadings10378383loadings
loanings9348013loanings
loathings1344213loathings
lodgings11336243lodgings
loggings11398233loggings
longings10408563longings
loping93921413lop_ing_
lopping123815223lopping_
lordings10368503lordings
losings82810623l_osings
lowing104623273l_owing_
lupines93912503lup_ines
lupins84514463lup_in_s
lutings83311053l_utings
lyings10488503l__yings
mailings113011923mailings
makings145413153ma_kings
mallings113413093mallings
mapping143413993mapping_
markings153410233markings
marlings113713483marlings
maskings15448743maskings
matings104516203ma_tings
mattings11369673mattings
mawing124020803ma_wing_
mayings134410503ma_yings
mowings13328483_mowings
napkins1336673napkin_s
napping123514183napping_
packings174310063packings
paddings13297003paddings
pagings114411063pa_gings
pairings11398313pairings
palings103915823pa_lings
papains11312363papain_s
parawings1535813parawings
pargings123410163pargings
parings104219213pa_rings
parkings153610673parkings
partings113513733partings
passings11409873passings
pavings134011633pa_vings
pawing124519553pa_wing_
pings85830883__p_ings
pipings12338253pip_ings
plaitings12296243plaitings
plankings16326113plankings
plannings12325453plannings
plantings12348403plantings
platings113611363pla_tings
racings105015123ra_cings
railings93412153railings
raisings9338443raisings
rankings13389163rankings
rapines95120863rap_ines
raping94829853rap_ing_
rapping123619103rapping_
raspings11337853raspings
ratings84217403ra_tings
ravings114614493ra_vings
rawins95617623ra_win_s
redwings13305733redwings
rowings113710363_rowings
sackings15389633sackings
sacrings11278923sacrings
sailings93513253sailings
saltings92811253saltings
samplings1435553samplings
sapling103217863sapling_
sapping123519313sapping_
savings114412953sa_vings
sawing104323813sa_wing_
sayings113610833sa_yings
sewings11369173_sewings
showings15246883showings
slammings14234123slammings
slapping133510833slapping_
slashings13316203slashings
slatings94011723sla_tings
slattings10346073slattings
spacings13287043spacings
spaeings11276253spaeings
springs104415923_springs
swings104714453__swings
tailings93211673tailings
takings124512563ta_kings
talkings13358403talkings
tannings9268633tannings
taping94222393tap_ing_
tapping123317133tapping_
tattings9408823tattings
tawing104521553ta_wing_
toppings13286423toppings
trappings14265753trappings
uppings12257123_uppings
upswings1433003upswings
upwinds13224223_upwinds
vaporings1544093vaporings
viewings1533973viewings
waddings14356463waddings
waitings123413743waitings
walkings16327313walkings
wapping153514603wapping_
warnings12358453warnings
washings15419273washings
waxings18366453wa_xings
waxwing2154723waxwing_
wings95727243___wings
wrappings17253713wrappings
yapping153412613yapping_
yawing134215613ya_wing_
yawping16357333yawping_
zapping213211473zapping_

Search took 10 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.1701051123.5
2DLD Change Limit1461623038.83016552.9
3Display Results3033030.1232463.4
 (SQL Overall)1786913039.12319586.9
 
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.