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

204 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
mantlings1220723(None) 
bantlings12216601bantlings
mantling112012611mantling_
anglings10228272_anglings
antings85015582_ant_ings
bantling112612002bantling_
catlings113712042ca_tlings
eanlings9128472ean_lings
fatlings12359302fa_tlings
gantlines1039332gantlines
handlings14237342handlings
mailings113011922ma_ilings
mallings113413092ma_llings
mangling122312622mangling_
marblings14225542marblings
marlings113713492ma_rlings
matings104516212ma_t_ings
mattings11369672ma_ttings
muntings11289812munt_ings
panelings12107452panelings
rattlings10235512rattlings
sandlings11238092sandlings
scantlings1393312scantlings
ablings1038743_a_blings
actings104512463_act_ings
aneling82719503_aneling_
angling92816043_angling_
anilines8415143_anilines
anilingus1043113_anilingus
anilins7416793_anilin_s
ankling122912063_ankling_
anteing8312813_anteing_
antikings1446233_antikings
antilogs949603_antilogs
anting75827023_ant_ing_
antlions839193_antlions
anythings1642593_anythings
babblings13194373babblings
bankings15489403ban_kings
bantengs1134593bant_engs
bastings114214693bast_ings
battings114010573ba_ttings
battling113110493battling_
bottlings12215293bottlings
brandlings1443993brandlings
bundlings13235563bundlings
bunglings13235213bunglings
buntings11348773bunt_ings
buntlines11207153buntlines
cagelings1335413cagelings
callings113613833ca_llings
canaling112016413canaling_
candling122313873candling_
cannings113710333can_nings
cantinas102713773cant_inas
canting104725903cant_ing_
carlings114015853ca_rlings
castings113614053cast_ings
castling11311233castling_
catling104819793ca_tling_
catlins93818843ca_tlin_s
centrings12227603centrings
chitlings15255903chitlings
dabblings15193883dabblings
dandling112511733dandling_
dangling112611233dangling_
darklings1533983darklings
darlings103710383da_rlings
dartling1039563dartling_
eanling81416673ean_ling_
earthlings1443613earthlings
eastings93412953east_ings
eatings84616443ea_t_ings
failings123811013fa_ilings
farthings1635233farthings
fastings124011943fast_ings
fatling113815683fa_tling_
fettlings1353753fettlings
flatlings13315823flatlings
fondlings14224893fondlings
gangling112411403gangling_
gantline9410903gantlin_e
gatings95212823ga_t_ings
gentling1048453gentling_
handling132312713handling_
hangings13258583han_gings
hanting114124483hant_ing_
huntings12328053hunt_ings
inklings13246383_inklings
jangling17249623jangling_
kartings13418523kart_ings
kindlings15195273kindlings
kitlings13318103_kitlings
landings103110073lan_dings
landlines1039763landlines
lanolines939983lanolines
lanolins8310533lanolin_s
lastings94214423last_ings
lathings12469853la_things
mackling172710063mackling_
maculing13219583maculing_
mailing102923343ma_iling_
mainlines1138513mainlines
maintains1167103maintain_s
makings145413163ma__kings
maligns1038133ma__ligns
malines93625603ma__lines
malling103623663ma_lling_
malting103219083malt_ing_
manacling1446283manacling_
managing1239093managing_
manakins14209763manakin_s
mandolines1347103mandolines
mandolins1248433mandolin_s
manikins14189723manikin_s
manliness111310123man_liness
manning103616383man_ning_
mantids103113623mant_i_ds
mantillas1147043mantillas
mantis83926033mant_i__s
mantises10317923mant_ises
mantles94820703mantl__es
mantlets104611203mantl_ets
manuring1139223manuring_
mappings15296413ma_ppings
marbling13179883marbling_
markings153410243ma_rkings
marlines103818713ma_rlines
marling103322763ma_rling_
marlins93420473ma_rlin_s
marting103325013mart_ing_
martinis103311613mart_inis
martins93322063mart_in_s
maskings15448753ma_skings
masting104325823mast_ing_
mating94832913ma_t_ing_
matins84527783ma_t_in_s
matting103620143ma_tting_
mattins93316143ma_ttin_s
mauling103315683ma_uling_
mayings134410513ma__yings
meanings11329163mean__ings
meetings11287413meet_ings
mendings12338303men_dings
middlings14194313middlings
millings113712583m_illings
mingling122010933mingling_
minings103912073min__ings
minting103020813mint_ing_
modelings1335563modelings
mottling11197753mottling_
mountings12266163mount_ings
munting103718773munt_ing_
muntins92715133munt_in_s
naethings1343873naethings
nestlings1074313nestlings
paddlings14224363paddlings
paintings12327093paint_ings
palings103915823pa__lings
paneling111013623paneling_
panellings1344533panellings
panting104025423pant_ing_
partings113513733part_ings
plantings12348403plant_ings
railings93412153ra_ilings
rankings13389173ran_kings
rankling132610113rankling_
ranting84025413rant_ing_
ratings84217413ra_t_ings
ratlines83815293ra_tlines
ratlins73615583ra_tlin_s
rattling92510873rattling_
ravelings13377383ravelings
sailings93513253sa_ilings
saltings92811253salt_ings
samplings1435553samplings
sandling102214413sandling_
santolinas1043753santolinas
saplings11269803sa_plings
scantling12107233scantling_
settlings1054683settlings
tacklings16235853tacklings
tailings93211673ta_ilings
tangling101712543tangling_
tannings9268633tan_nings
tattings9408823ta_ttings
tattling9259473tattling_
tinklings14224663tinklings
tintings9288713tint_ings
turtlings10184873turtlings
unslings937283_unslings
vaultings13233633vaultings
wafflings1943023wafflings
waitings123413743wait_ings
wangling132310993wangling_
wanting114220173want_ing_
wattling12258783wattling_
weanlings1394413wean_lings
windlings14236723windlings
wintling12249923wintling_
witlings12328443_witlings
xanthines1966723xanthines
xanthins1846943xanthin_s
yeanlings1393693yean_lings

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412046.89021573.4
3Display Results2042040.0932193.5
 (SQL Overall)1786912047.40624127.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.