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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

67 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
splice10491510(None) 
slice74925821s_lice
spice95528811sp_ice
spliced124310591spliced
splicer114710521splicer
splices113914381splices
spline86020531spline
aplite8316392aplite
cilice103213352cilice
lice66045062__lice
malice104818482malice
pice84641092_p_ice
place94824612_place
plaice10311552_plaice
plica9613372_plica
plicae10410952_plicae
plie65127392_pli_e
police102918562police
price93725412_price
resplice1237252resplice
saice75424052s_aice
salic73424712salic_
saline65132702saline
semplice1447012semplice
sice65545592s__ice
silica8311242silica
silicle937752silicle
sliced94416312s_liced
slicer84117602s_licer
slices84022852s_lices
slick115520522s_lick
slide64725412s_lide
slime74925752s_lime
slipe75626132s_lipe
sluice849512sluice
solace83415822solace
space95325672sp_ace
specie10412222specie
speise84614252speise
spence103813792spence
spic85227432sp_ic_
spica94717942sp_ica
spicae104313702sp_icae
spiced115218312sp_iced
spicer104719312sp_icer
spices104326032sp_ices
spicey134414232sp_icey
spick134519072sp_ick
spics94123242sp_ics
spicy125417712sp_icy
spike114922842sp_ike
spile75230082sp_ile
spine76534422sp_ine
spire75828692sp_ire
spite75430662sp_ite
splake1259782splake
splicers12338112splicers
spliff1438602spliff
splined105013112splined
splines94718892splines
splint85223282splint
split75729012spli_t
splits85416412splits
splore81611302splore
sprite84421772sprite
spruce103910872spruce
surplice1246202surplice

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551672.36034979.2
3Display Results67670.0164187.5
 (SQL Overall)178691672.71965719.4
 
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.