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

188 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
prattling124630(None) 
brattling1236001brattling
rattling92510871_rattling
sprattling1363051sprattling
battling113110492_battling
brittling1235552brittling
dratting10389662dratt_ing
patting103722342p_att_ing
pettling1168212p_ettling
platting114813032platt_ing
prating103424452pra_t_ing
prattlingly1752242prattlingly
prettying1536042prettying
ratting83822362_ratt_ing
rattlings10235512_rattlings
tattling9259472_tattling
twattling1332692twattling
wattling12258782_wattling
wrastling1335522wrastling
bantling112612003_bantling
batting104422273_batt_ing
blatting114111653blatt_ing
bottling11279143_bottling
brabbling1334963brabbling
brailing113514793bra_iling
brailling1247773brailling
brambling1635543brambling
brandling1348253brandling
bratticing1543923bratticing
brawling143210043bra_wling
bristling1246663bristling
castling11311233_castling
catling104819793_ca_tling
catting103922643_catt_ing
chatting142810143chatt_ing
craaling112711353cra_aling
crackling18157003crackling
cradling122411453cra_dling
crafting143710173craft_ing
crankling16147293crankling
cratering12312653cratering
crating103725203cra_t_ing
crawling143110513cra_wling
cuittling1234103cuittling
cuttling1138203_cuttling
dartling1039563_dartling
deratting1139513deratt_ing
drabbling1544553drabbling
drafting13339413draft_ing
draggling1354613draggling
drawling13318673dra_wling
earthling1346193earthling
embattling1542193embattling
fatling113815683_fa_tling
fatting113818703_fatt_ing
fettling1266773_fettling
flatling123410013fla_tling
flatting123511253flatt_ing
frazzling2143153frazzling
fretting122711523frett_ing
fritting123510703fritt_ing
grabbling1564583grabbling
grafting13319623graft_ing
granting103514523grant_ing
grappling1544993grappling
grating93923183gra_t_ing
graveling1457383graveling
grayling1338003gra_yling
gritting10309983gritt_ing
gruntling1134263gruntling
guttling1037293_guttling
hatting113920233_hatt_ing
kittling1336063_kittling
kraaling13186663kra_aling
mantling112012613_mantling
matting103620143_matt_ing
mottling11197753_mottling
nettling957213_nettling
orating83520323ora_t_ing
paddling13218643p_addling
paling93530133p_a__ling
palling104024493p_a_lling
paneling111013633p_aneling
panting104025423p_ant_ing
parceling1438443parceling
parling103823773p_a_rling
paroling113316213p_aroling
partaking1698673partaking
parting103527383p_art_ing
partying14168893p_artying
pasting103826553p_ast_ing
patching163212753p_atching
patining11312303p_atining
pattering122314433p_attering
pealing104123203pea__ling
pearling11912013pea_rling
pestling111010253p_estling
petting103720953p_ett_ing
pirating11314513pira_t_ing
pistoling1268493pistoling
pitting103618873p_itt_ing
plaiting113113513plait_ing
planting113515383plant_ing
plating103823073pla_t_ing
plaything1843853plaything
plotting113011013plott_ing
potting103720893p_ott_ing
practicing1775583practicing
practising1586363practising
praising113214563pra_ising
praline93019753pra__line
prancing132612163pra_ncing
pranging123012723pra_nging
pranking153813383pra_nking
prattle9208833prattl__e
prattled11246533prattl_ed
prattler10166343prattl_er
prattlers11195333prattlers
prattles10189413prattl_es
prawning1446963pra_wning
praying133717323pra__ying
preacting142412533preact_ing
preattuning1443043preattuning
prefiling1549533prefiling
presettling1444453presettling
pretaping1439133pretaping
pretelling1338143pretelling
pretyping1764943pretyping
prickling1836533prickling
prilling113413413pr_illing
printing113216083print_ing
profiling1548233profiling
prowling1449993pr_owling
putting103218573p_utt_ing
puttying1434953p_uttying
rabbling13239333_rabbling
raddling11229773_raddling
raffling1567063_raffling
rafting113815753_raft_ing
railing83325643_ra_iling
rambling131810773_rambling
rankling132610113_rankling
ranting84025413_rant_ing
rassling939013_rassling
rating74938703_ra_t_ing
ratlin64116523_ra_tlin_
ratline74517813_ra_tline
ratlins73615583_ra_tlins
rattening10288763_rattening
rattlingly1443653_rattlingly
raveling123414373_raveling
retiling93319483_retiling
retitling1039773_retitling
retting83425883_rett_ing
rootling9269953_rootling
rotting82919683_rott_ing
rustling9249983_rustling
rutting82718043_rutt_ing
scantling12107233scantling
scatting113311813scatt_ing
scuttling1234243scuttling
settling978943_settling
shuttling1334293shuttling
slatting94014233slatt_ing
spatting113111763spatt_ing
splatting1235983splatt_ing
spraddling1542313spraddling
sprawling15175123spra_wling
startling1037373startling
swatting12309593swatt_ing
tatting84019523_tatt_ing
throttling1442803throttling
trachling1537823trachling
trailing92916093tra_iling
trameling1249053trameling
trampling1436973trampling
traveling1349053traveling
trawling122710783tra_wling
trotting92510913trott_ing
uprating11311113upra_t_ing
vatting113614853_vatt_ing
vittling1236143_vittling
warstling1335063warstling
whittling1634383whittling
wrangling1456223wrangling
wrassling1334273wrassling
wrathing15248923wra_thing
wrestling1336063wrestling

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411887.86018911.1
3Display Results1881880.0802350.0
 (SQL Overall)1786911888.37621333.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.