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

137 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
spiling10291970(None) 
piling95025591_piling
sailing83927371sailing
smiling103915441smiling
soiling83422321soiling
speiling113612971speiling
spicing123914531spicing
spieling113212521spieling
spiking144312881spiking
spilings11308811spilings
spilling113113941spilling
spiring103918181spiring
spiting103917621spiting
spoiling112911551spoiling
ailing74331012_ailing
aspiring1138872aspiring
bailing103723522bailing
boiling103819672boiling
ceiling103416722ceiling
coiling103723452coiling
exiling15311082exiling
failing113521332failing
filing103823762_filing
foiling113317652foiling
guiling93214212guiling
hailing113820692hailing
heiling113616362heiling
jailing153415842jailing
mailing102923342mailing
moiling103417662moiling
nailing83419962nailing
oiling74925312_oiling
opining10311742opining
paling93530132_paling
pieing93917652_pieing
piing85218832_pi_ing
piking133719642_piking
pilings103313612_pilings
pilling103722562_pilling
pining93726532_pining
piping114017452_piping
poling93526502_poling
puling93621402_puling
railing83325642railing
riling74227972_riling
roiling83220452roiling
sailings93513252sailings
saining83621392saining
sapling103217862sapling
scaling103519372scaling
sealing83528562sealing
seeling83522002seeling
seining84020772seining
seising84018862seising
seizing174114832seizing
selling83225832selling
shieling123512402shieling
shilingi1233842shilingi
shilling123315382shilling
shining113816522shining
sibling10814422sibling
siding83822132s_iding
sidling9915422sidling
silking123715592s_ilking
siloing83215502s_iloing
silting83320482s_ilting
siping94220632s_iping
sipping123117432sipping
siring75128312s_iring
siting74126622s_iting
sizing163616442s_izing
skiing113610192ski_ing
skilling132911332skilling
skirling13249062skirling
skiting123812502skiting
skiving15298372skiving
slicing103514642slicing
sliding93114552sliding
sliming102913952sliming
sling66028802s__ling
sliping103314412sliping
smiting103014442smiting
snailing92912972snailing
sniping103712052sniping
soling74226822s_oling
sopiting11310762sopiting
spacing123614492spacing
spading113114382spading
spaeing103413542spaeing
spalling113213462spalling
sparing104823872sparing
sparling112714532sparling
spaying133014622spaying
speeling112713122speeling
speiring113711262speiring
spelling113315232spelling
spewing133110452spewing
spiering112713352spiering
spiffing17237082spiffing
spindling13136272spindling
spinning113310812spinning
spiraling1237952spiraling
spirting112913632spirting
spitting113012322spitting
splicing1338962splicing
spline86020532sp_line
splining11310772splining
splint85223282sp_lint
spoking143212222spoking
spooling113212562spooling
sporing104319412sporing
spring94526012sp_ring
spuing94313362sp_uing
spuming1248522spuming
spying123913252sp_ying
staling83925422staling
stifling122110912stifling
stilling93415322stilling
stilting93312402stilting
styling112910652styling
suiting83419002suiting
suppling1359042suppling
swilling123511932swilling
swiping13319822swiping
swirling12249142swirling
swiving14358952swiving
tailing82923102tailing
tiling73426552_tiling
toiling83219022toiling
unpiling1139752unpiling
upfling1337092upfling
uppiling1335852uppiling
vailing113817942vailing
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.373479064.3
2DLD Change Limit1076711373.25033129.5
3Display Results1371370.0632174.6
 (SQL Overall)1786911373.68648478.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.