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

452 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
wangling13231099(None) 
angling92816041_angling
dangling112611231dangling
gangling112411401gangling
jangling17249621jangling
mangling122312621mangling
tangling101712531tangling
twangling1434451twangling
waggling14197061waggling
wrangling1456221wrangling
aneling82719502_aneling
angeling102811732_angeling
anglings10228272_anglings
ankling122912062_ankling
argling92812732_argling
banging114019862bang_ing
bantling112611992bantling
bungling12269542bungling
canaling112016402canaling
candling122313872candling
daggling12237062daggling
dandling112511732dandling
danging103716092dang_ing
eagling91113602ea_gling
eanling81416672ean_ling
gaggling10217462gaggling
ganging103216192gang_ing
gargling11239202gargling
haggling14227272haggling
handling132312712handling
hanging123518702hang_ing
jingling17188572jingling
mantling112012602mantling
mingling122010932mingling
paneling111013622paneling
panging113319112pang_ing
pungling12228662pungling
ranging94120262rang_ing
rankling132610112rankling
sandling102214412sandling
singling101913002singling
spangling1336372spangling
swingling14156202swingling
tanging93419522tang_ing
tangoing10177892tangoing
tingling102210802tingling
twanging13287062twang_ing
wabbling16207742wabbling
waddling14237932waddling
waffling1845422waffling
wagging133313352wa_gging
waging114318382wa_g_ing
wailing113620902wa_iling
waling104525302wa__ling
walling113520972wa_lling
wambling16198442wambling
waning103623802wan__ing
wanking154216782wan_king
wanning113816212wan_ning
wanting114220172wan_ting
warbling14198942warbling
warsling12198592warsling
wattling12258782wattling
wauling112713112wa_uling
wawling143810962wa_wling
waygoing1633272waygoing
weanling12118642wean_ling
whanging16267142whang_ing
wiggling14217292wiggling
windling132212262windling
wingding1436452wingding
winging123718712wing_ing
winkling16298292winkling
wintling12249922wintling
addling10229833_addling
ageing84213403_a_geing
aging77026353_a_g_ing
ailing74331013_a_iling
ambling121411793_ambling
angering102113803_angering
angina7413133_ang_ina
anglice1089213_anglice
anguine839913_anguine
anilin6417793_anilin_
aniline7418473_aniline
anilins7416793_anilins
anteing8312813_anteing
anting75827023_an_ting
anviling1239743_anviling
arguing9248733_arguing
awning105013393awn__ing
babbling12228693babbling
badging123712793badg_ing
baffling1756053baffling
bagging123316983ba_gging
bailing103723523ba_iling
baling94829693ba__ling
balling104424763ba_lling
banding114921413ban_ding
bandying15218073bandying
baning95127833ban__ing
banking144621353ban_king
banning103818233ban_ning
bantlings12216593bantlings
barging114018483barg_ing
battling113110493battling
bawling133813863ba_wling
bingeing12237643bingeing
binging113619383bing_ing
boggling13257163boggling
bonging113316373bong_ing
brandling1348253brandling
bugling113615343_bugling
bundling12219703bundling
bunging113616503bung_ing
bunglings13235213bunglings
burgling12239303burgling
cabling124017553ca_bling
cackling172610943cackling
cadging123610973cadg_ing
cageling12310843cageling
caging105321023ca_g_ing
cajoling18318423cajoling
calling103826773ca_lling
canalling1239543canalling
canceling14310163canceling
candying15188993candying
caning94128623can__ing
canning103620133can_ning
canoeing11310213canoeing
canting104725903can_ting
carling103727063ca_rling
caroling113317003caroling
castling11311233castling
catling104819793ca_tling
caviling14310113caviling
changeling1745673changeling
changing153211513chang_ing
clanging124012123clang_ing
congaing1239823congaing
crankling16147293crankling
dabbling14227973dabbling
daddling12258233daddling
dancing113611563dan_cing
dangering12239303dangering
danglier1056753danglier
dappling1436843dappling
darkling1437483darkling
darling93418363da_rling
dartling1039563dartling
dawdling14236373dawdling
dazzling1834363dazzling
dindling112411163dindling
dinging103618613ding_ing
draggling1354613draggling
dunging103012623dung_ing
dwindling15123793dwindling
eanlings9128473ean_lings
enabling1138603enabling
entangling1244313entangling
fabling133413623fa_bling
fadging134210243fadg_ing
fagging133714763fa_gging
failing113521333fa_iling
falling113621583fa_lling
fancying1735353fancying
fanglike1636823fanglike
fanning113615073fan_ning
fatling113815683fa_tling
fenagling1434553fenagling
finagling1434703finagling
flanging132710583flang_ing
fondling13189353fondling
fugling124212513_fugling
gabbling14238073gabbling
gabling113514543ga_bling
gagging93013523ga_gging
gaging94718403ga_g_ing
galling93921963ga_lling
gambling14218963gambling
gangbang1342963gangbang
gangland1145193gangland
ganglia946613gangli_a
ganglial1054663ganglial
gangliar1064123gangliar
ganglier1047603ganglier
ganglion1044393ganglion
ganglions1144063ganglions
gantline9410903gantline
gaoling93314653ga_oling
garbling12249453garbling
gauging10339963gaug_ing
gaveling133410163gaveling
gentling1048453gentling
giggling10227043giggling
gnarling10217603gnarling
goggling10246283goggling
gonging103713033gong_ing
guggling10236353guggling
gurgling11267323gurgling
hackling183310163hackling
hagging133114683ha_gging
hailing113820693ha_iling
haling104229783ha__ling
handing123518893han_ding
handlings14237343handlings
hangaring1438013hangaring
hangings13258583hang_ings
hanking154619103han_king
hanseling1338063hanseling
hanting114124483han_ting
hassling1236803hassling
hauling113714433ha_uling
higgling14217163higgling
hinging123917103hing_ing
hondling132210013hondling
hongiing1335603hongiing
ingoing9311023_ingoing
inkling122911303_inkling
jagging173311993ja_gging
jailing153415843ja_iling
janglier1656113janglier
jiggling18226363jiggling
joggling18215573joggling
juggling18225603juggling
kegling13309363_kegling
kindling14229623kindling
kinging133115033king_ing
labeling11311643labeling
ladling92813393la_dling
lagging103316733la_gging
lalling83519623la_lling
lancing103314123lan_cing
landing92819323lan_ding
landline9311443landline
lanolin7310643lanolin_
lanoline8311953lanoline
lanolins8310533lanolins
laughing1335933laughing
longeing10177593longeing
longing93915783long_ing
longline938763longline
lunging93714213lung_ing
mackling172710063mackling
maculing13219583maculing
mailing102923343ma_iling
malling103623663ma_lling
manacling1446283manacling
managing1239093managing
manning103616383man_ning
mantlings12207223mantlings
manuring1139223manuring
marbling13179883marbling
marling103322763ma_rling
mauling103315683ma_uling
nagging102613043na_gging
nailing83419963na_iling
niggling11227443niggling
noncling11310763noncling
ogling83211883__ogling
ongoing938793_ongoing
paddling13218643paddling
paging104020403pa_g_ing
paling93530133pa__ling
palling104024483pa_lling
pandying15217663pandying
panelings12107453panelings
panelling1239073panelling
pangolin1147773pangolin_
pangolins1247373pangolins
panning104019393pan_ning
panting104025423pan_ting
parging113318603parg_ing
parling103823763pa_rling
paroling113316213paroling
pindling122110983pindling
pinging113419553ping_ing
ponging113416153pong_ing
pranging123012723prang_ing
rabbling13239333rabbling
raddling11229773raddling
raffling1567063raffling
ragging103516683ra_gging
raging85126433ra_g_ing
railing83325643ra_iling
rambling131810773rambling
ranching141712043ranching
ranking124320883ran_king
ranting84025413ran_ting
rassling939013rassling
rattling92510873rattling
raveling123414373raveling
ridgling11258203ridgling
ringing93521283ring_ing
runkling13217613runkling
saddling11239593saddling
sagging103116103sa_gging
sailing83927373sa_iling
sampling13510643sampling
sandaling112010553sandaling
sanding93520603san_ding
sandlings11238093sandlings
sanguine947633sanguine
saning75127643san__ing
sapling103217863sa_pling
scantling12107233scantling
shingling14136953shingling
singeing10209933singeing
singing93221423sing_ing
slanging103413433slang_ing
snagging11319373snagging
snailing92912973snailing
snarling92513183snarling
stanging104013653stang_ing
strangling1256403strangling
swaddling1543813swaddling
swagging14328093swa_gging
swaging124210633swa_g_ing
swanking16399963swan_king
swanning12338813swan_ning
swindling14135833swindling
swingeing14144693swingeing
swinging133411113swing_ing
tabling103216033ta_bling
tackling153211123tackling
tagging103014913ta_gging
tagline82412453ta_gline
tailing82923103ta_iling
tanglier948073tanglier
tanking123918793tan_king
tanning83618253tan_ning
tattling9259463tattling
tingeing10198533tingeing
tinging93619443ting_ing
tinkling13239233tinkling
toggling11206483toggling
tonging93314513tong_ing
tonguing1046263tonguing
twaddling1552713twaddling
twattling1332693twattling
twingeing14143373twingeing
twinging13278403twing_ing
twinkling1743643twinkling
unageing1036273unageing
unaging9510933unag_ing
ungluing1035863_ungluing
unsling8313643_unsling
untangling1244123untangling
vailing113817943va_iling
vanning113912463van_ning
venging123710943veng_ing
wadding133711943wa_dding
waddying17204723waddying
wading114619533wa__ding
wafering15208893wafering
waffing173710243wa_ffing
wafflings1943023wafflings
wafting143911663wa_fting
wagering13219523wagering
wagglier1344323wagglier
waggoning1543593waggoning
wagoning1336923wagoning
waifing142910893wa_ifing
wairing113414313wa_iring
waisting123615213waisting
waiting113618953wa_iting
waiving14329633wa_iving
wakening1636323wakening
waking144821383wa__king
walking154013303wa_lking
waltzing2134263waltzing
wandering143310973wandering
wangan10311223wang_an_
wangans1149503wang_ans
wangle103817503wangl__e
wangled123312413wangl_ed
wangler113312653wangl_er
wanglers123310033wanglers
wangles113416933wangl_es
wangun1037103wang_un_
wanguns1135023wang_uns
wantoning1337083wantoning
wapping153514603wa_pping
warding123918143wa_rding
waring105029443wa__ring
warking153519573wa_rking
warming133515083wa_rming
warning113717093wa_rning
warping133715183wa_rping
warring113717973wa_rring
warstling1335063warstling
washing145119283wa_shing
wasting114422843wa_sting
watching173011173watching
watering122316313watering
waughting1743123waughting
wauking153410013wa_uking
wavering152410543wavering
waving134018203wa__ving
waxing174215283wa__xing
waxwing2154723wa_xwing
waygoings1742203waygoings
weakling16106763weakling
weaning114117193wean__ing
weanlings1394413wean_lings
weaseling1335613weaseling
wedeling1338773wedeling
wedging13308723wedg_ing
weighing1635283weighing
welling112920313w_elling
wenching17328863wenching
wending123816843wen_ding
whaling143910773w_haling
wheeling15318593wheeling
whiling143511743w_hiling
whingding1833183whingding
whingeing1733513whingeing
whinging16247723whing_ing
whirling15237163whirling
widdling14228733widdling
wigging133413833w_igging
wildling13248083wildling
wiling103024293w__iling
willing113821613w_illing
wimbling16186543wimbling
wimpling16207483wimpling
winching17359903winching
wincing133413903win_cing
winding123517913win_ding
windlings14236713windlings
wingdings1543683wingdings
winglike1635593winglike
wining103625053win__ing
winking153317963win_king
winning113516553win_ning
witling113215813w_itling
wobbling16246923wobbling
wonning113210793won_ning
wonting113214103won_ting
wrassling1334273wrassling
wrastling1335523wrastling
wriggling1533813wriggling
wringing13279623wring_ing
wrinkling17144953wrinkling
wronging13327393wrong_ing
wyling13368553w__yling
yanking154512463yan_king
yawling14369183ya_wling
yeanling12107063yean_ling
youngling1463273youngling
zagging193210453za_gging
zinging183513943zing_ing

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461624527.39019778.3
3Display Results4524520.1902378.9
 (SQL Overall)1786914527.75023056.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.