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

104 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
pical9552437(None) 
apical10913901apical
epical10413391epical
pial65636701pi_al
pibal95217321pibal
pica85831491pica_
picas94626521picas
picul95015361picul
pipal95118351pipal
plical10411681plical
tical76021491tical
apicals1159922apicals
binal75323822binal
cecal94619112cecal
cicala10310052cicala
cicale10314502cicale
decal85523232decal
dial55935062di_al
ducal84816422ducal
fecal105119212fecal
final83922032final
fiscal1139332fiscal
focal104917672focal
jacal14313702jacal
laical8312322laical
local74820272local
mica86428252mica_
micas96823052micas
nicad8312612nicad
nicol71113292nicol
nidal65217102nidal
nival84915772nival
optical1149862optical
paca85132242paca_
pacas96029402pacas
pal56761672p__al
papal95820672papal
pascal10812372pascal
peal68648102p_eal
pecan91919032pecan
pedal86022502pedal
penal75228372penal
petal76526892petal
phial10313202phial
pia56848032pi_a_
pian66136092pi_an
pias66542552pi_as
pibals103813082pibals
pic76046822pic__
picara10311902picara
picaro10311322picaro
pice84641092pic_e
pick125933812pic_k
pickax2135912pickax
pickle144215652pickle
picks135226142picks
picky165416942picky
picot95031012picot
pics85633912pic_s
piculs103511752piculs
pika106322952pika_
pikas114218092pikas
pilaf103923482pilaf
pilar75221502pilar
pilau73618522pilau
pilaw103913742pilaw
pill65339462pi_ll
pima85428652pima_
pimas94725102pimas
pina65842632pina_
pinas75434452pinas
pineal84817682pineal
pinnal84814272pinnal
pipals104213642pipals
pita65436432pita_
pitas77427672pitas
pixel143911902pixel
plica9613372plica_
plicae10410952plicae
primal104014622primal
pupal97616872pupal
rial45938092ri_al
rictal83113182rictal
rival85216502rival
riyal84413432riyal
sial45938832si_al
sisal54217732sisal
spica94717942spica_
spicae104313702spicae
spicas104715822spicas
spinal84915312spinal
spiral83715342spiral
spital83813872spital
ticals83214712ticals
tidal64516442tidal
tincal83913362tincal
topical1139952topical
typical1436342typical
vial76731092vi_al
vicar10513862vicar
vinal85725812vinal
viral86419592viral
vital84819672vital
vocal104715642vocal

Search took 5 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 Filter178691538000.656272394.8
2DLD Change Limit538001043.39015870.2
3Display Results1041040.0631650.8
 (SQL Overall)1786911044.10943487.7
 
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.