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

182 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
picas9462652(None) 
micas96823051micas
pacas96029401pacas
pias66542551pi_as
pica85831491pica_
pical95524371pical
picks135226141picks
pics85633911pic_s
pikas114218091pikas
pimas94725101pimas
pinas75434451pinas
pitas77427671pitas
spicas104715821spicas
apical10913902apical
apicals1159922apicals
apices104916262apices
bias64738162bi_as
bices95029962bices
bimas95521742bimas
cacas95627982cacas
chicas135916472chicas
cocas95926572cocas
cycas126513822cycas
dicast9315572dicast
dices86434242dices
dicks125824692dicks
ditas65923672ditas
divas95418582divas
epical10413392epical
epics95014282epic_s
ericas8315462ericas
fices106031162fices
ficus105015492ficus
fincas113512072fincas
gigas75415582gigas
hicks145322172hicks
ices66129642_ices
ichs96214712_ichs
kicks104420082kicks
kinas95626912kinas
kivas124614732kivas
licks115325392licks
limas75627632limas
liras56021982liras
litas54923772litas
mica86428252mica_
micks135525372micks
mics87435152mic_s
minas75434112minas
nicad8312612nicad
nicads938332nicads
nicks114920492nicks
nipas77116672nipas
ocas66729632_ocas
orcas75918622orcas
paca85132242paca_
paces96741112paces
pachas135017142pachas
packs135528932packs
pacs85842182pac_s
pacts95125802pacts
paisas84317492paisas
papas94927492papas
paras76143042paras
pas58775742p__as
peas65755062p_eas
pecan91919032pecan
pecans101515832pecans
pechs125516202pechs
pecks135724432pecks
pecs84634102pec_s
pia56848032pi_a_
pial65636702pi_al
pian66136092pi_an
pians75126962pians
pibal95217322pibal
pibals103813082pibals
pic76046822pic__
picara10311902picara
picaras11311282picaras
picaro10311322picaro
picaros11310892picaros
pice84641092pic_e
pick125933812pic_k
pickax2135912pickax
picky165416942picky
picot95031012picot
picots104616442picots
picul95015362picul
piculs103511752piculs
pieces104217272pieces
piers75926332piers
pies66949602pi_es
pietas84516502pietas
pigs76634222pi_gs
pika106322952pika_
pikes115031032pikes
pikis115116392pikis
pilaf103923482pilaf
pilafs113511022pilafs
pilar75221502pilar
pilau73618522pilau
pilaus84114132pilaus
pilaw103913742pilaw
pilaws11399432pilaws
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pima85428652pima_
pimps114616982pimps
pina65842632pina_
pines76048862pines
pings85830882pings
pinks115729382pinks
pinnas85315512pinnas
pins65558452pi_ns
pintas85021392pintas
pints75936222pints
pions75826392pions
pious74621272pious
pipal95118352pipal
pipals104213642pipals
pipes96030142pipes
pips85837132pi_ps
pirns76020092pirns
pis56362032pi__s
piscos105112592piscos
pisos76021062pisos
piss65033332pi_ss
pita65436432pita_
piths105817542piths
pits66348742pi_ts
pittas86014522pittas
pixes144323172pixes
pizzas1646982pizzas
pleas75627032pleas
plica9613372plica_
plicae10410952plicae
plical10411682plical
pocks135022962pocks
prices104524542prices
pricks144414262pricks
primas104418102primas
proas75028802proas
psoas75012982psoas
puces94924632puces
pucks134322102pucks
pujas145513322pujas
pumas95121562pumas
punas74826752punas
pupas95219282pupas
pyas96225702p_yas
rias45540592ri_as
rices75536152rices
ricks115126132ricks
sices75637272sices
sicks115127622sicks
sics65234092sic_s
sikas94617022sikas
simas75727552simas
socas74026182socas
spica94717942spica_
spicae104313702spicae
spices104326032spices
spicks144814992spicks
spics94123242spic_s
tical76021492tical
ticals83214712ticals
ticks115823292ticks
tics65729632tic_s
vicar10513862vicar
vicars11712262vicars
vices105725532vices
vigas94817882vigas
vinas85126342vinas
vincas113912452vincas
visas84317652visas
vivas114815022vivas
wiccas1336542wiccas
wicks144619362wicks
yucas106013912yucas

Search took 2 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.300595636.7
2DLD Change Limit538001821.43637465.2
3Display Results1821820.0463956.5
 (SQL Overall)1786911821.782100275.5
 
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.