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

156 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
schilling1528639(None) 
chilling143512181_chilling
schillings16243271schillings
shilling123315381s_hilling
childing15288502_childing
chitling142910662_chitling
hilling113821772__hilling
schooling1546942schooling
scrolling12187802scrolling
sculling112910992sc_ulling
shelling123515212s_helling
shieling123512402s_hieling
shillings13348092s_hillings
shrilling13307692shrilling
skilling132911332s_killing
spilling113113942s_pilling
stilling93415322s_tilling
swilling123511932s_willing
achieving1843303achieving
anvilling1336833anvilling
billing103823853__billing
brailling1247773brailling
calling103826773_c_alling
cavilling1536383cavilling
ceiling103416723_cei_ling
celling103921263_c_elling
chalking183310063_chalking
chiding143911593_chi_ding
chilli114312773_chilli__
chillier13328423_chillier
chillies134113483_chillies
chillily1644113_chillily
chillingly1943363_chillingly
chillis124411603_chilli_s
chiming153311833_chi_ming
chining133316843_chi_ning
chinking183210893_chinking
chinning14329653_chinning
chipping18389793_chipping
chirking18339383_chirking
chirming16318643_chirming
chirping16278863_chirping
chirring142610173_chirring
chiseling1536403_chiseling
chiselling1644683_chiselling
chitlin12269283_chitlin_
chitlings15255903_chitlings
chitlins13289393_chitlins
chivying2034973_chivying
coiling103723453_coi_ling
culling103921303_c_ulling
devilling1436703devilling
drilling103311983_drilling
filling113520803__filling
frilling123011493_frilling
gilling93520383__gilling
grilling103811533_grilling
helling114623223__helling
hilding123713533__hilding
hilloing12158303__hilloing
hilting113316893__hilting
hulling113619013__hulling
killing123118723__killing
milling103223683__milling
nilling83619563__nilling
perilling12410003perilling
pilling103722563__pilling
prechilling1943743prechilling
prilling113413413_prilling
quilling182510003_quilling
rebilling12228833rebilling
refilling13299333refilling
rilling84023623__rilling
sailing83927373s_ai_ling
scabbling1634863scabbling
scalding12339393sc_alding
scaling103519373sc__aling
scalping133410453sc_alping
scantling12107233scantling
scheduling1742013scheduling
scheming1636633sch_eming
schiller13296473schill_er
schillers14285663schillers
schoolings1644013schoolings
schussing1542953schussing
scolding12278913sc_olding
scowling1458283sc_owling
scrawling15195573scrawling
scribbling1742553scribbling
scribing13238183scri_bing
scrieving1534133scrieving
scrimping1634953scrimping
scripting1437473scripting
scriving14258763scri_ving
scrupling1435193scrupling
scuffling1843613scuffling
sculking15307913sc_ulking
sculping13298943sc_ulping
scumbling1634423scumbling
scuttling1234243scuttling
selling83225833s__elling
shauling1249393s_hauling
shawling1558223s_hawling
shealing123415463s_healing
shelving15278173s_helving
shielding1434553s_hielding
shielings13237123s_hielings
shifting152910383s_hifting
shilingi1233843s_hi_lingi
shimming16278253s_himming
shingling14136973s_hingling
shining113816523s_hi_ning
shinning123211023s_hinning
shipping163611253s_hipping
shirking163210473s_hirking
shirring122910443s_hirring
shirting123213613s_hirting
shitting123212663s_hitting
shoaling123111753s_hoaling
shooling123012563s_hooling
sibling10814423s__ibling
sidling9915423s__idling
silking123715593s__ilking
siloing83215503s__iloing
silting83320483s__ilting
skillings14246133s_killings
skirling13249063s_kirling
skulling13258103s_kulling
smelling113712723s_melling
smiling103915443s_mi_ling
snailing92912973snai_ling
snelling93913563s_nelling
soiling83422323s_oi_ling
spalling113213463s_palling
speiling113612973spei_ling
spelling113315233s_pelling
spieling113212523s_pieling
spiling102919703s_pi_ling
spoiling112911553spoi_ling
squalling1935173squalling
stalling95116703s_talling
stifling122110913s_tifling
stilting93312403s_tilting
stripling1257783stripling
strolling10238793strolling
swelling123212753s_welling
swirling12249143s_wirling
thirling12248583_thirling
thrilling13276693thrilling
tilling83522783__tilling
trilling92815963_trilling
twilling12268673_twilling
unwilling1337163unwilling
whiling143511743_whi_ling
whirling15237163_whirling
willing113821613__willing

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.1601116818.8
2DLD Change Limit1486411567.71619264.0
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.93922508.0
 
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.