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

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

151 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
solicit931574(None) 
solicits10311021solicits
colicin11313742colicin
elicit8417202_elicit
illicit949832illicit
licit74327682__licit
salicin9311222salicin
silicic1147602silicic
solecist10910782solecist
solicited1247972solicited
solicitor1144402solicitor
solidi73813152solidi_
solidity1248112solidity
allicin949953allicin
bolivia1246063bolivia
codicil1246813codicil
colic95726173colic__
colicine12312993colicine
colicins12312853colicins
colicky1835783colicky
colics104219903colic_s
colitic112916193colitic
colitis92617353colitis
complicit1747433complicit
conicity15411093conicity
culicid1247383culicid
deficit1339673deficit
delict94320333delic_t
delimit10311733delimit
dolci84912603dol_ci_
domicil1246433domicil
elicits9311233_elicits
explicit1946463explicit
felicity1647913felicity
folacin1238053folacin
folic105319323folic__
helicity1648503helicity
holibut1297483holibut
holiest104319623holiest
holist94723213holi_st
implicit1446813implicit
ionicity1348823ionicity
licht104723493__licht
limit73126343__limit
ocicat101412813_ocicat
oolitic92512883oolitic
polecat11313143polecat
police102918563polic_e
policed123212233policed
policer113112683policer
polices113118053polices
policies122415663policies
policing13311673policing
policy133211513polic_y
politic112918713politic
polycot14510123polycot
relict83623903relic_t
salacity1347853salacity
salic73424713salic__
salicine10311703salicine
salicins10310933salicins
salient7419763salient
salinity1138893salinity
scilicet1249543scilicet
scolecite1345653scolecite
scolices1238733scolices
select82621173selec_t
semifit1249973semifit
sericin9312843sericin
shilpit1247103shilpit
silica8311243silic_a
silicas9310603silicas
silicate10312623silicate
silicide1147833silicide
silicify1644273silicify
silicium1286563silicium
silicle937753silicle
silicon9117533silicon
slice74925823s_lic_e
sliced94416313s_liced
slicer84117603s_licer
slices84022853s_lices
slicing103514643s_licing
slick115520523s_lic_k
slicks124816113s_licks
sliest66621953s_liest
slight103416003s_light
slipt76627483s_li_pt
slit46250103s_l__it
sobeit8315363so_beit
sodic84917493sodic__
soffit1237883so_ffit
solace83415823solac_e
solaced102911063solaced
solacer93011103solacer
solaces93116133solaces
solacing11310133solacing
solanin7311943solanin
solaria7312493solaria
solatia7312253solatia
soldi65717203sol_di_
solecise1089073solecise
solecism12107593solecism
solecists1187073solecists
solecize1998383solecize
solei55624343sol_ei_
soleret7321233soleret
soli46637013sol__i_
solicitant1254243solicitant
soliciting1346813soliciting
solicitors1244213solicitors
solicitous1244173solicitous
solicitude1352873solicitude
solid65025083sol__id
solider82912453solider
solidest9310383solidest
solidify1544193solidify
solidly1137353solidly
solids74116403soli_ds
solidus8338113solidus
soling74226823soli_ng
solion6616383soli_on
solions7513753solions
solipsist1144563solipsist
soliquid1844303soliquid
soliton7410233soliton
soloist7915893soloist
solvent10310833solvent
somitic111512633somitic
sonic75225293sonic__
sonicate10310933sonicate
sonics84315633sonic_s
soricine10710883soricine
soritic91414433soritic
soviet9720153sovi_et
spirit83519923s_pirit
splice104915103splic_e
spliced124310593spliced
splicer114710523splicer
splices113914383splices
splicing1338963splicing
splint85223283spli_nt
split75729013spl__it
stickit1339463s_tickit
stolidity1344683stolidity
strict84821043stric_t
sublimit1247513sublimit
sulci7615053sul_ci_
tolidin839243tolidin
tonicity1348543tonicity
toxicity2045683toxicity

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271516.12321889.1
3Display Results1511510.0463282.6
 (SQL Overall)1786911516.57527177.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.