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

112 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
smiling10391544(None) 
sailing83927371sailing
smiting103014441smiting
soiling83422321soiling
spiling102919701spiling
ailing74331012_ailing
ambling121411792ambling
bailing103723522bailing
besmiling1436262besmiling
boiling103819672boiling
ceiling103416722ceiling
coiling103723452coiling
emailing113010042emailing
exiling15311082exiling
failing113521332failing
filing103823762_filing
foiling113317652foiling
guiling93214212guiling
hailing113820692hailing
heiling113616362heiling
jailing153415842jailing
mailing102923342mailing
miking134218462_miking
milding113615452_milding
milking143712762_milking
milling103223682_milling
milting103619122_milting
miming114317262_miming
mining94225452_mining
miring93723802_miring
mixing164713942_mixing
moiling103417662moiling
muling93519882_muling
nailing83419962nailing
oiling74925312_oiling
piling95025592_piling
railing83325642railing
riling74227972_riling
roiling83220452roiling
sailings93513252sailings
saining83621392saining
sampling13510642sampling
sapling103217862sapling
scaling103519372scaling
sealing83528562sealing
seeling83522002seeling
seining84020772seining
seising84018862seising
seizing174114832seizing
selling83225832selling
shieling123512402shieling
shilingi1233842shilingi
shilling123315382shilling
shining113816522shining
sibling10814422sibling
siding83822132s_iding
sidling9915422sidling
silking123715592s_ilking
siloing83215502s_iloing
silting83320482s_ilting
simlin8311732simlin_
simlins9311842simlins
siping94220632s_iping
siring75128312s_iring
siting74126622s_iting
sizing163616442s_izing
skiing113610192ski_ing
skilling132911332skilling
skirling13249062skirling
skiting123812502skiting
skiving15298372skiving
slicing103514642slicing
sliding93114552sliding
sliming102913952sliming
sling66028802s__ling
sliping103314412sliping
smelling113712732smelling
smelting11339712smelting
smilingly1545742smilingly
smirking15277232smirking
smoking143210522smoking
snailing92912972snailing
sniping103712052sniping
soling74226822s_oling
speiling113612972speiling
spicing123914532spicing
spieling113212522spieling
spiking144312882spiking
spilings11308812spilings
spilling113113942spilling
spiring103918182spiring
spiting103917622spiting
spoiling112911552spoiling
staling83925422staling
stifling122110912stifling
stilling93415322stilling
stilting93312402stilting
styling112910652styling
suiting83419002suiting
swilling123511932swilling
swiping13319822swiping
swirling12249142swirling
swiving14358952swiving
tailing82923102tailing
tiling73426552_tiling
toiling83219022toiling
unsmiling1256872unsmiling
vailing113817952vailing
veiling113615292veiling
wailing113620902wailing
whiling143511742whiling
wiling103024292_wiling

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.376475242.0
2DLD Change Limit1076711123.37331921.4
3Display Results1121120.0462434.8
 (SQL Overall)1786911123.79547085.9
 
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.