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

136 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
modelling133688(None) 
modeling12311071mode_ling
yodelling1435191yodelling
bowelling1566492bowelling
cordelling1446382cordelling
dowelling1466252dowelling
hovelling1636162hovelling
medalling1346912medalling
melling102822622m__elling
modelings1335552mode_lings
modeming1437102mode_ming
monellin1047372monellin_
monellins1147412monellins
morselling1346322morselling
remodelling1542782remodelling
rowelling1366992rowelling
towelling1366252towelling
yodeling1357672yode_ling
belling103825073__belling
bevelling15227453bevelling
bolling103820883bo__lling
boweling143410683bowe_ling
celling103921263__celling
coddling13258473cod_dling
codling114418953cod__ling
compelling1746553compelling
corbelling1546713corbelling
covelline1446533covelline
cudgelling1543323cudgelling
cupelling1436283cupelling
dealing94323233__dealing
deleing93313953__deleing
delving123711573__delving
dolling93817373__dolling
doweling13279763dowe_ling
duelling103410733_duelling
dulling93418273__dulling
dwelling13368413_dwelling
embowelling1952123embowelling
excelling1935643excelling
expelling1936133expelling
felling113321133__felling
fuelling123410153_fuelling
gavelling14286873gavelling
gelling93219763__gelling
godling103513403god__ling
grovelling1554163grovelling
gruelling1155603gruelling
helling114623223__helling
hostelling1446163hostelling
houselling1445753houselling
hoveling15189593hove_ling
impelling1436913impelling
indwelling1543763indwelling
jelling153516613__jelling
jewelling2034833jewelling
knelling13319023_knelling
kvelling16146513_kvelling
labelling1238073labelling
levelling13206973levelling
libelling1236873libelling
lolling83415773lo__lling
madeleine1244133madeleine
malling103623663m__alling
marcelling1545593marcelling
marvelling1645363marvelling
medaling121912243med_aling
meddling13257933med_dling
melding113414273m__elding
melting103317753m__elting
metalling1249593metalling
mewling13329513m__ewling
middling13249333mid_dling
milling103223683m__illing
misdealing1457363misdealing
modelist11310503mode_list
modelled1236423modell_ed
modeller1136613modell_er
modellers1245393modellers
moderating1448803moderating
modifying1944663modifying
modillion1244203modillion
modillions1343673modillions
modulating1446373modulating
moiling103417663mo__iling
moldering1367853molde_ring
molding114213753mo__lding
molesting1237743molesting
molting103517173mo__lting
morseling1238073morseling
moseying1436853mose_ying
mottling11197753mo_ttling
moulding12258143mo_ulding
moulting112710313mo_ulting
muddling13268593mud_dling
mulling103819993m__ulling
noddling11237253nod_dling
panelling1239073panelling
pedalling1346663pedalling
polling102920383po__lling
pommelling1743613pommelling
propelling1556933propelling
quelling18259793_quelling
ravelling13269243ravelling
rebelling122111163rebelling
refelling132211313refelling
remodeling1445023remode_ling
repelling122312753repelling
reselling102213833reselling
retelling102112493retelling
revelling132412553revelling
rodeoing1037253rode_oing
rolling83620413ro__lling
roweling122811123rowe_ling
selling83225833__selling
shelling123515213_shelling
shovelling1744063shovelling
sideling101012173side_ling
smelling113712723_smelling
snelling93913563_snelling
spelling113315233_spelling
swelling123212753_swelling
telling83321083__telling
toddling11187003tod_dling
tolling83418563to__lling
totalling1036513totalling
toweling122910373towe_ling
towellings1452893towellings
trowelling1484913trowelling
underling111514613underling
unselling10810333unselling
upwelling1535233upwelling
wedeling1338773wede_ling
welling112920313__welling
yelling113516703__yelling
yodling123610253yod__ling

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.1731032896.0
2DLD Change Limit1486411367.78019105.5
3Display Results1361360.0632158.7
 (SQL Overall)1786911368.01622291.8
 
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.