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

126 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
solicits1031102(None) 
solicit9315741solicit_
colicins12312852colicins
elicits9311232_elicits
policies122415662policies
salicins10310932salicins
solecist10910782solecist
solecists1187072solecists
solicited1247962solicited
solicitor1144402solicitor
solicitors1244212solicitors
solicitous1244172solicitous
solidity1248112solidity
allicins1049653allicins
bolivias1345393bolivias
codicils1346043codicils
colicin11313743colici_n
colicine12312993colicine
colicines13311203colicines
colics104219903colic__s
colitis92617343coliti_s
conicity15411093conicity
culicids1345623culicids
deficits1447273deficits
delicts104012253delic_ts
delimits1137573delimits
domicils1345073domicils
elicit8417203_elicit_
explicits2044933explicits
felicity1647913felicity
folacins1337203folacins
helicity1648503helicity
holibuts1363953holibuts
holists104413963holi_sts
illicit949833illicit_
ionicity1348823ionicity
lichts113712383__lichts
licit74327683__licit_
limits82514133__limits
ocicats11137413_ocicats
polecats1248833polecats
policers12259993policers
polices113118053polic_es
policing13311673policing
politics122513813politics
polities102722343polities
polycots1547763polycots
relicts94414593relic_ts
salacity1347853salacity
salicin9311223salici_n
salicine10311703salicine
salicines11310003salicines
salients839563salients
salifies11314793salifies
salinity1138893salinity
scolecite1345643scolecite
scolecites1445183scolecites
scolices1238733scolic_es
selects91912143selec_ts
sericins10312463sericins
silicas9310603silic_as
silicate10312623silicate
silicates11311523silicates
silicic1147603silici_c
silicide1147833silicide
silicides1247073silicides
silicify1644273silicify
silicious1146433silicious
silicium1286563silicium
siliciums1384633siliciums
silicles1037073silicles
silicons10107143silicons
slicers94114923s_licers
slices84022853s_lic_es
slicing103514643s_licing
slicks124816113s_lic_ks
slights112810723s_lights
slits56128853s_l__its
soffits1335093so_ffits
solacers10268893solacers
solaces93116133solac_es
solacing11310133solacing
solanins8310513solanins
solecise1089073solecise
solecises1189103solecises
solecism12107593solecism
solecisms1396703solecisms
solecize1998383solecize
solecizes2087863solecizes
solerets839693solerets
solicitant1254243solicitant
solicitants1352173solicitants
soliciting1346813soliciting
solicitude1352873solicitude
solicitudes1482883solicitudes
solidest9310383solidest
solidi73813153solidi__
solidify1544193solidify
solidities1149483solidities
solids74116403sol__ids
solidus8338113soli_dus
solions7513743soli_ons
solipsist1144563solipsist
solipsists1252953solipsists
soliquids1943523soliquids
solitons849573solitons
soloist7915893sol_oist
soloists869153soloists
solonets838233solonets
solvents1136763solvents
sonicate10310933sonicate
sonicates11410383sonicates
sonics84315633sonic__s
soricine10710883soricine
soviets1087293sovi_ets
spirits94112623s_pirits
splicers12338113splicers
splices113914383splic_es
splicing1338963splicing
splints94511743spli_nts
splits85416413spl__its
stolidity1344683stolidity
sublimits1345543sublimits
tolidins948023tolidins
tonicity1348543tonicity
toxicity2045683toxicity

Search took 9 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621267.98618302.3
3Display Results1261260.0602100.0
 (SQL Overall)1786911268.20221786.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.