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

159 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
drillings1128582(None) 
drilling103311981drilling_
frillings13265801frillings
billings113412632_billings
brislings12236362brislings
dialings10329822d_ialings
diallings1134992diallings
drinkings15244772drinkings
drippings15313902drippings
drivings13265762dri_vings
drolling103510762drolling_
dwellings14244212dwellings
fillings122910502_fillings
frilling123011492frilling_
grilling103811532grilling_
killings133710482_killings
millings113712582_millings
prilling113413412prilling_
quillings19225742quillings
riflings12227302_riflings
rilling84023622_rilling_
rollings9419952_rollings
shillings13348092shillings
skillings14246132skillings
triflings13235972triflings
trilling92815962trilling_
trollings10286692trollings
twillings13234912twillings
bellings113811153_bellings
billing103823853_billing_
birlings11359613_birlings
brailling1247773brailling_
bridgings14254293bridgings
bridling122610583bridling_
briefings1543733briefings
brilliants1243073brilliants
brisling112410843brisling_
buildings1334253buildings
callings113613833_callings
ceilings11397993cei_lings
chilling143512183chilling_
chitlings15255903chitlings
cribbings16273173cribbings
dabblings15193883dabblings
dairyings1442633dairyings
darklings1533983darklings
darlings103710383d_arlings
dealings103510703d_ealings
devilling1436703devilling_
dialing94318173d_ialing_
dialling10310783dialling_
diggings12316623d_iggings
dillies84122163d_illi_es
dirling93316073d_irling_
dolling93817373d_olling_
draftings14334203draftings
draglines1145993draglines
drawings13386283dr_awings
drawling13318673drawling_
dredgings13252953dredgings
dressings11265373dressings
dribbing14325883dribbing_
dribbling1533713dribbling_
drifting13338733drifting_
drillers9429723drill_ers
drills74414203drill___s
drinking14308913drinking_
dripping14278033dripping_
drivelines1444593drivelines
driveling1445763driveling_
drivelling1543983drivelling_
driving123910713dri_ving_
drizzling1943023drizzling_
drooling102610423drooling_
droppings15264503droppings
drubbings15262883drubbings
drumlins1144993drumlin_s
ducklings17204013ducklings
duelling103410733duelling_
dulling93418273d_ulling_
dumplings15213853dumplings
dwelling13368413dwelling_
erlkings1333563er_lkings
failings123811013fai_lings
filings115213073_fi_lings
filling113520803_filling_
gildings11356973_gildings
gilling93520383_gilling_
graylings1433883graylings
gruelings1163763gruelings
gruellings1272323gruellings
hildings13347503_hildings
hilling113821773_hilling_
hirelings1365763hirelings
killing123118723_killing_
kiltings13327083_kiltings
kitlings13318103_kitlings
mailings113011923mai_lings
mallings113413093_mallings
millines102718063_millines
milling103223683_milling_
nilling83619563_nilling_
perilling12410003perilling_
pilings103313613_pi_lings
pilling103722563_pilling_
prickings18315653prickings
primings13338143pri_mings
printings12268103printings
quilling182510003quilling_
quiltings19214683quiltings
quislings19184713quislings
railings93412153_railings
rallyings13313633_rallyings
redrilling1246073redrilling_
reelings94012563_reelings
ribbings13275923_ribbings
ridglings12214183_ridglings
ridings93412093_ri_dings
rieslings1034493_rieslings
rifling112815013_rifling_
riggings11327133_riggings
riling74227973_ri_ling_
rinsings9318013_rinsings
risings83211893_ri_sings
rolling83620413_rolling_
rulings83310383_r_ulings
sailings93513253sai_lings
schillings16243273schillings
shielings13237123shielings
shilling123315383shilling_
shrilling13307693shrilling_
siblings11108123_siblings
skilling132911333skilling_
spellings12296553spellings
spilings11308813spi_lings
spilling113113943spilling_
stilling93415323stilling_
striplings1344183striplings
swellings13296103swellings
swilling123511933swilling_
tailings93211673tai_lings
thrilling13276693thrilling_
tilings84212793_ti_lings
tilling83522783_tilling_
trifling122411503trifling_
trillions947183trillions
trilliums1144333trilliums
trimmings14254453trimmings
tripling112712553tripling_
trippings14225723trippings
trithings13246603trithings
trolling93212493trolling_
twilling12268673twilling_
veilings12357313vei_lings
wildings13287933_wildings
wildlings14244923_wildlings
willing113821613_willing_
witlings12328443_witlings
writings12298113wri_tings

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.466383457.1
2DLD Change Limit1486411598.28317945.3
3Display Results1591590.0762092.1
 (SQL Overall)1786911598.82520248.3
 
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.