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

270 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
piscine1161097(None) 
piscina1177041piscina
piscinae1285211piscinae
discing113914592discing
fascine12510582fascine
hircine1239142hircine
miscite11314382miscite
oscine8311562_oscine
phocine1438832phocine
piecing12410452piecing
piscinal1285842piscinal
piscinas1275482piscinas
pishing134314372pishing
pismire1135352pismire
pissing103914802pissing
porcine11312842porcine
pristine10313502pristine
abscise1145953abscise
airline7315033airline
arcsine94512393arcsine
arsine64021043ars_ine
asinine7310723asinine
biocide1237323biocide
brucine1138273brucine
calcine11315273calcine
cassine93817283cassine
cine66242943___cine
citrine92514023citrine
cosine83823513cos_ine
crocine11314153crocine
cuisine9310423cuis_ine
cystine1239333cystine
destine83719953destine
diamine10311983diamine
diazine1738933diazine
dicing105718763di_cing
discant103017263discant
discase102912863discase
disci85815023disci__
disciple1346673disciple
disclike15208653disclike
discoing12511453discoing
dishing124017103dishing
disking134615493disking
dislike122913453dislike
dissing94517683dissing
divine103514463di_vine
eosine64519413eos_ine
epicene1148593epi_cene
episcia1145133episci_a
episcias1244893episcias
episcope1445833episcope
exscind1743753exscind
fasciae1247523fasciae
fascines13310143fascines
ficin103516723fi_cin_
ficins113513983fi_cins
fishing143913863fishing
fishline14237583fishline
fissile10269653fissile
fisting113818123fisting
glycine1335713glycine
hipline12311423hipline
hissing114213143hissing
histing113720373histing
histone10312843histone
hyoscine1644183hyoscine
icing86017753_i_cing
imine75821063_i_mine
incise83515333_incise
incite83618733_incite
incline9314643_incline
intine61021983_intine
iodine74618653_iodine
isatine7311763_isatine
isling71213883_isling
isocline1047293_isocline
isoline7314013_isoline
jasmine1636643jasmine
kissing122911053kissing
leucine938073leucine
limacine1246003limacine
lisping103412753lisping
listing84020593listing
lysine94210553lys_ine
midline102315103midline
milline92519113milline
mincing123314333mincing
miocene1147923miocene
misbind1258273misbind
miscible1447673miscible
miscited13310423miscited
miscites12313783miscites
miscode12310413miscode
miscoin11311433miscoin_
miscoined1448443miscoined
miscoins12311083miscoins
miscue10412223misc_ue
miscuing1338733miscuing
misdone10310863misdone
misfile122611553misfile
misfire12229893misfire
misgive13339033misgive
mislie83219153misli_e
mislike132914833mislike
mislive122812693mislive
missile92815403missile
missing103619073missing
missive122413143missive
mistime11312613mistime
misting103623383misting
mistune9310653mistune
niacin8310223niacin_
niacins938543niacins
obscene1145243obscene
oscines9310363_oscines
pacing114522753p_acing
pardine103616723pardine
pashing135120513pashing
passing104318423passing
passive12239593passive
pastie85525523pasti_e
pastime114611973pastime
pastina93914593pastina
pasting103826553pasting
patine85328123p_atine
peacing124117073peacing
peising103416763peis_ing
pennine93712953pennine
pepsine11310603pepsine
picante11310523pi_cante
pice84641093pi_c__e
picking163418333picking
pickle144215653pi_ckle
picnic123410263pi_cnic
picoline12310853picoline
picrite111911313picrite
pidgin10259813pidgin_
pidgins11259123pidgins
piece96717993piec__e
piecings1345343piecings
pieing93917653pi_eing
piercing1346663piercing
piggie103210773piggi_e
piggin103111093piggin_
pigging123614673pigging
piggins113010473piggins
piglike14157313piglike
pigskin1444353pigskin_
pigskins1544253pigskins
piing85218833pi__ing
piking133719643pi_king
piling95025593pi_ling
pilling103722563pilling
pimping143812123pimping
pinbone1138183pinbone
pinching163711053pinching
pine67755713p___ine
pinecone1246063pinecone
pinene82915643pi_nene
pinging113419553pinging
pining93726533pi_ning
pinite8321243pi_nite
pinkie124414273pinki_e
pinking143918943pinking
pinning103417853pinning
pinyin112710613pinyin_
pipeline12149503pipeline
piperine122011833piperine
piping114017453pi_ping
pipkin14248603pipkin_
pipkins15328183pipkins
pippin92810303pippin_
pipping113414743pipping
pippins10319753pippins
piquing1935873piquing
piscary1437423piscary
piscivore1652363piscivore
pisco96314983pisc__o
piscos105112593pisc_os
pishoge1336693pishoge
pismires1235883pismires
pisolite10310373pisolite
pissant91012503pissant
piste75824603pis__te
pistil83915073pisti_l
pistils93314303pistils
pistole92414313pistole
piston83515923piston_
pistons93016373pistons
pitching163411113pitching
pithing134014053pithing
pitting103618873pitting
pitying132910243pitying
pixie145415523pi_xi_e
placing123815283placing
pliocene1244593pliocene
pliskie1394543pliski_e
poising103617103pois_ing
poncing122913583poncing
pontine92419053pontine
porcini1137633porcini
porcino1138113porcino
posing93922643pos_ing
postie84123963posti_e
postin83521033postin_
posting105622243posting
postins93721203postins
potline91015233potline
poutine93316823poutine
praline93019743praline
precipe133012123precipe
precise113518173precise
prescind1338393prescind
pricing123417343pricing
primine113214823primine
principe1445683principe
prising103321453pris_ing
prissing113011453prissing
pristane10310343pristane
procaine12312273procaine
proline92321593proline
promine112819443promine
propine113020213propine
puisne856353puis__ne
purine85321893p_urine
purline93516533purline
pushing133615453pushing
puslike1347563puslike
rescind10410393rescind
reshine102816943reshine
ricin74620213ri_cin_
ricing94822763ri_cing
ricins83618703ri_cins
rising74025883ris_ing
risking123914243risking
rusine63916593rus_ine
scene77220573__scene
scone74621833__scone
seine55732873__seine
sestine73017923sestine
shine85533093__shine
siccing12319513siccing
sine46560623__s_ine
siskin1079783siskin_
siskins1159583siskins
spicing123914533spi_cing
spine76534423__spine
swine85625303__swine
ticcing12308633ticcing
tisane6311573tis_ane
ursine64114123urs_ine
vaccine1437323vaccine
vespine1237903vespine
vicing124014243vi_cing
visaing11279333visaing
viscid1237473visci_d
viscose1237863viscose
viseing11299163viseing
vising103915873vis_ing
visive1257873vis_ive
vitrine102511363vitrine
wincing133413903wincing
wishing144114893wishing
wising103318223wis_ing
wisping133711943wisping
wissing113212943wissing
wisting113519743wisting
zincing192910283zincing
zincite1837233zincite

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.420425454.8
2DLD Change Limit1340272705.84622926.3
3Display Results2702700.0932903.2
 (SQL Overall)1786912706.35928100.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.