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

110 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
sibling1081442(None) 
siblings11108121siblings
sidling9915421sidling
aiblins9311472aiblins
ailing74331012ai_ling
ambling121411792ambling
bibbing11299612bibbing
billing103823852billing
birling104317052birling
cabling124017552cabling
dialing94318172dialing
dibbing133110892dibbing
dibbling14247332dibbling
dirling93316072dirling
fabling133413622fabling
fibbing15339462fibbing
filing103823762fi_ling
filling113520802filling
gabling113514542gabling
gibbing13339372gibbing
gibing103712352gib_ing
gilling93520382gilling
hilling113821772hilling
idling8912882_idling
isling71213882_isling
jibbing19338062jibbing
jibing16379622jib_ing
kibbling17225702kibbling
killing123118722killing
kitling123313572kitling
libeling1139872libeling
milling103223682milling
nibbing12339552nibbing
nibbling13256502nibbling
nilling83619562nilling
oiling74925312oi_ling
piling95025592pi_ling
pilling103722562pilling
ribbing123111952ribbing
rifling112815012rifling
riling74227972ri_ling
rilling84023622rilling
sabbing123314742sabbing
sabeing102611862sabeing
sabring102614842sabring
sailing83927372sailing
sapling103217862sapling
scaling103519372scaling
sealing83528562sealing
seeling83522002seeling
selling83225832selling
shieling123512402shieling
shilling123315382shilling
siccing12319512siccing
sicking143720172sicking
sickling152910332sickling
sideling101012182sideling
siding83822132si_ding
sieging92613202sieging
sieving112311232sieving
sifting113014592sifting
sighing123311662sighing
signing92713962signing
silking123715592silking
siloing83215502siloing
silting83320482silting
simlin8311732simlin_
simlins9311842simlins
singing93221422singing
singling101913002singling
sinking123320542sinking
sinning83918442sinning
siping94220632si_ping
sipping123117432sipping
siring75128312si_ring
siting74126622si_ting
sitting83519632sitting
sizing163616442si_zing
sizzling17225782sizzling
skilling132911332skilling
skirling13249062skirling
sling66028802s__ling
smiling103915442smiling
snibbing13295892snibbing
sobbing127612882sobbing
soiling83422322soiling
soling74226822s_oling
spieling113212522spieling
spiling102919702spiling
spilling113113942spilling
stabling112913652stabling
staling83925422staling
stifling122110912stifling
stilling93415322stilling
styling112910652styling
subbing123915582subbing
subline9316892subline
subring104116262subring
swilling123511932swilling
swirling12249142swirling
tabling103216032tabling
tiling73426552ti_ling
tilling83522782tilling
tirling83315732tirling
titling83715792titling
vialing113614162vialing
wiling103024292wi_ling
willing113821612willing
wimbling16186542wimbling
witling113215812witling

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 Limit1076711103.28332796.5
3Display Results1101100.0303666.7
 (SQL Overall)1786911103.68648478.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.