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

147 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
spoolings1224539(None) 
spooling113212561spooling_
pooling103219092_pooling_
schoolings1644012schoolings
shooling123012562shooling_
shootings13266062shootings
snooling93013472snooling_
sparlings12257152sparlings
spellings12296552spellings
spilings11308812sp_ilings
spoiling112911552spoiling_
spoofing14228362spoofing_
spooking15269802spooking_
spooning112811442spooning_
spooring113111462spooring_
spoutings12245152spoutings
stooling93113132stooling_
toolings9248472_toolings
bloodings13245273bloodings
bookings15358733_bookings
bowlings14408753_bowlings
codlings123110103_codlings
cookings15358603_cookings
cooling103422573_cooling_
cowlings14359783_cowlings
drooling102610423drooling_
floorings13245093floorings
fooling113117373_fooling_
footings12248833_footings
foulings12327943_foulings
fowlings15377243_fowlings
gloomings13283973gloomings
godlings11367493_godlings
goslings10297553_goslings
moorings11257713_moorings
noonings9246653_noonings
oolongs845953__oolongs
palings103915823_p_alings
peelings11339523_peelings
pilings103313613_p_ilings
poling93526503_p_oling_
polling102920383_polling_
poohing133112323_poohing_
pooing93820683_poo_ing_
pooping123615443_pooping_
poplins11313153_poplin_s
postings112912303_postings
potlines10714213_potlines
prolines102619693_prolines
prolongs11347613_prolongs
pulings103511323_p_ulings
purlings113910283_purlings
respooling1355743respooling_
rollings9419953_rollings
roofings12256023_roofings
sailings93513253s_ailings
samplings1435553samplings
sandlings11238093sandlings
saplings11269803s_aplings
schooling1546943schooling_
scoldings13224133scoldings
scooping133610633scooping_
scooting113012643scooting_
scourings12235293scourings
scoutings12306143scoutings
scowling1458293scowling_
seedlings11195953seedlings
semolinas1145433semolinas
settlings1054683settlings
shealings13317563shealings
shielings13237123shielings
shillings13348093shillings
shoaling123111753shoaling_
shooing112112913shoo_ing_
shooting122812863shooting_
shoppings17295073shoppings
shorings12269483s_horings
showings15246883s_howings
showrings1644063showrings
siblings11108123s_iblings
skillings14246133skillings
skiorings14243793skiorings
skoaling13227213skoaling_
slings74618013s___lings
smockings18264283smockings
snooding102910433snooding_
snooking133010583snooking_
snooping113811323snooping_
snooting92813203snooting_
snoozing18319083snoozing_
snoozling19314343snoozling_
soarings93210393s_oarings
soiling83422323s_oiling_
soling74226823s__oling_
soloing82813803s_oloing_
sooting82820963s_ooting_
sorings83817253s__orings
spacings13287043sp_acings
spaeings11276253sp_aeings
spalling113213463spalling_
spankings16215003spankings
sparling112714533sparling_
speakings16345933speakings
speedings13265403speedings
speeling112713123speeling_
speerings12276843speerings
speiling113612973speiling_
spelling113315233spelling_
spieling113212523spieling_
spiling102919703sp_iling_
spilling113113943spilling_
spinnings12294853spinnings
splines94718893sp__lines
splints94511743sp__lints
spoking143212223sp_oking_
sponging1238823sponging_
spongins1136563spongin_s
spookiness1644433spookiness
spoolers10349363spool_ers
spools85115913spool___s
spoonies101911753spooni_es
spoons84116023spoo__n_s
sporing104319413sp_oring_
sporting112415463sporting_
spotting112812093spotting_
spousing11198733spousing_
spouting113511953spouting_
springs104415923sp__rings
stablings12256103stablings
starlings10237923starlings
stealings10318853stealings
sterlings10308753sterlings
stockings16296093stockings
stooging102810043stooging_
stooking132711143stooking_
stoolies8311083stooli_es
stooping113012363stooping_
stylings12276233s_tylings
sucklings16225113sucklings
swellings13296103swellings
swooning12278203swooning_
swooping14338403swooping_
tooling82918313_tooling_
trollings10286693trollings
unspooling1343853unspooling_
upflings1433733up_flings
vanpoolings1751323vanpoolings

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.436409841.7
2DLD Change Limit1486411477.22020587.4
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.71923149.5
 
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.