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 “bilking” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

128 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
bilking14441355(None) 
balking143717351balking
biking135018171bi_king
bilging114212681bilging
billing103823851billing
bulking143815121bulking
milking143712761milking
silking123715591silking
ailing74331012ail_ing
backing165523442backing
bailing103723522bail_ing
baking135626622b_aking
balding114015062balding
baling94829692bal_ing
balling104424762balling
banking144621352banking
barking144724182barking
basking144718612basking
baulking1536002baulking
becking164416072becking
belling103825072belling
belting104119132belting
belying133612442belying
biasing103512452biasing
bibbing11299612bibbing
bidding123613512bidding
biding104720792bi_ding
bielding12237472bielding
biffing163510012biffing
bigging122815882bigging
bikini12418912bi_kini
billings113412632billings
biltong1034682biltong
binding113819382binding
binging113619382binging
binning103615452binning
birding114014922birding
birling104317052birling
birring103713062birring
biting95321822bi_ting
bitting103717292bitting
blinking153510622blinking
bluing94914482b_luing
boiling103819672boil_ing
boinking15378422boinking
bolling103820882bolling
bolting104416762bolting
bonking144116372bonking
booking143618382booking
borking144716172borking
braking143917712braking
bricking173911402bricking
brisking15329472brisking
broking143514822broking
bucking163617572bucking
building1237502building
bulging113514212bulging
bulling104324792bulling
bunking144016192bunking
burking143716322burking
busking144116572busking
calking144617782calking
dicking153617612dicking
diking124320242di_king
dinking133618282dinking
dirking133812602dirking
disking134615492disking
erlking1236702erlking
filing103823762fil_ing
filling113520802filling
filming133210352filming
finking154016602finking
gilding103813002gilding
gilling93520382gilling
hiking143617102hi_king
hilding123713532hilding
hilling113821772hilling
hilting113316892hilting
holking153512312holking
hulking153910982hulking
inking115119052_inking
irking114611752_irking
jilting153211742jilting
jinking193613542jinking
kicking133314022kicking
killing123118722killing
kilning12289022kilning
kilting123213852kilting
kinking113615152kinking
licking144118282licking
liking114319582li_king
lilting83515382lilting
linking123818252linking
miking134218462mi_king
milding113615452milding
milling103223682milling
milting103619122milting
nicking143516322nicking
nilling83619562nilling
oiling74925312oil_ing
oinking123714712oinking
picking163418332picking
piking133719642pi_king
piling95025592pil_ing
pilling103722562pilling
pinking143918942pinking
ricking143920232ricking
riling74227972ril_ing
rilling84023622rilling
risking123914242risking
sicking143720172sicking
siloing83215502siloing
silting83320482silting
sinking123320542sinking
sulking124514312sulking
talking123815822talking
ticking143218752ticking
tiling73426552til_ing
tilling83522782tilling
tilting83417102tilting
viking143414612vi_king
walking154013302walking
wicking173414772wicking
wilding123814292wilding
wiling103024292wil_ing
willing113821612willing
wilting113515912wilting
winking153317962winking

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711282.84637832.4
3Display Results1281280.0462782.6
 (SQL Overall)1786911283.26554729.2
 
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.