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

191 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
pinnace11351031(None) 
pinnaces12268861pinnaces
pinnacle12416961pinnacle
pinnae84414641pinna_e
pinnate93613741pinnate
binnacle12325632binnacle
finance1238582finance
inlace82513042_inlace
innage73011572_innage
innate63917312_innate
penance11313442penance
pennae84314032penna_e
penname11328552penname
pennate93314032pennate
pinna75320182pinna__
pinnacled14304502pinnacled
pinnacles13276042pinnacles
pinnal84814282pinna_l
pinnas85315522pinna_s
pinnated11338552pinnated
pinnule936002pinnule
pinwale1257842pinwale
anlace82513923_anlace
biennale1044103biennale
biface1358103bi_face
binate8419773bi_nate
binnacles13244583binnacles
bipinnate1342763bipinnate
connate9315753connate
dunnage9175213dunnage
enface112510353_enface
enlace82213233_enlace
fiance11310743fian_ce
finale94116763fi_nale
financed1435123financed
finances1338663finances
finback1865823finback
furnace1235943furnace
inane52820343_i_nane
incage93513623_incage
incase83615283_incase
induce93811533_induce
infare9313083_infare
ingate73018243_ingate
inhale9411523_inhale
inlaced10239873_inlaced
inlaces92512903_inlaces
inmate82917363_inmate
innages82911303_innages
insane6314893_insane
insnare748243_insnare
intact8314663_intact
intake10510863_intake
invade10157853_invade
jinnee13411573jinn_ee
kinase104210653ki_nase
linac7315413li_nac_
linacs8310813li_nacs
linage7713403li_nage
lindane839033lindane
lineage878983lineage
lineate7815153lineate
linkage1295963linkage
menace103216943_menace
minae75627723mi_na_e
mince95325233mi_n_ce
mintage101110123mintage
misname11119483misname
nance74721843__nance
pace86345773p___ace
palace104516923p_alace
panacea1137793p_anacea
panache1458433p_anache
pancake1536673pancake
panne76623653pann__e
pawnage1335873pawnage
peace95026083p__eace
penanced1338163penanced
penances12312443penances
pence94924453p_en_ce
penna74520203penna__
pennames12287793pennames
pennant9312493pennant
pennated11299543pennated
penne75423853penn__e
pennine93712953pennine
pentacle1239383pentacle
pentane9415743pentane
peonage1048723peonage
phenate12412203phenate
phonate12411813phonate
pianic103714123pianic_
picante11310523picante
pice84641103pi___ce
pickaxe2244623pickaxe
picnic123410263picnic_
picnics13297343picnics
picrate112014143picrate
piece96717993pi__ece
pierce104010393pi_erce
pikake11115803pi_kake
pileate93815923pileate
pillage103412603pillage
pina65842643pi_na__
pinang92611593pi_nang
pinangs10267793pinangs
pinas75434453pi_na_s
pinata83817223pi_nata
pinball1137933pinball
pinbone1138183pinbone
pincer104019173pi_n_cer
pinch125619303pi_n_ch
pine67755723pi_n__e
pineal84817693pinea_l
pineals93212853pineals
pinene82915653pi_nene
pinhole122010433pinhole
pinite8321243pi_nite
pinkeye16326493pinkeye
pinkie124414273pi_nkie
pinnately1443753pinnately
pinned94818383pinn_ed
pinner84521503pinn_er
pinners93518603pinners
pinnies93318443pinnies
pinning103417853pinning
pinniped1343853pinniped
pinnula934923pinnula
pinnulae1044183pinnulae
pinnulate1145763pinnulate
pinnules1036473pinnules
pinny105222063pinn__y
pinocle1138143pinocle
pinole83218783pi_nole
pinta75727053pinta__
pintada1096083pintada
pintado1096573pintado
pintail9311183pintail
pintano998993pintano
pintas85021393pinta_s
pintle83818263pi_ntle
pinwales1367963pinwales
pionic103515953pionic_
pipage1199143pi_page
pipeage1236203pipeage
piquance2144213piquance
piracy1339473pi_racy
pirate82322883pi_rate
pistache1545893pistache
pittance1246113pittance
place94824613p__lace
planate9314573planate
poignance1443593poignance
pomace123111913p_omace
ponce95222513p_on_ce
pounce105214093poun_ce
prance104318573pran_ce
preface14510923preface
prename11412643prename
prerace11414123prerace
prince104114763prin_ce
pronate9418873pronate
rennase738713rennase
signage937773signage
since75024173si_n_ce
sinkage1287263sinkage
sinuate7412163sinuate
sonance9310313sonance
spinach1435403spi_nach
spinage10289653spi_nage
spinate93114813spi_nate
spinnaker1542313spinnaker
tannage8209583tannage
tannate71813523tannate
tenace82715693_tenace
tinware1038603tinware
tonnage8168053tonnage
tunnage8166373tunnage
uniface1236953uniface
unlace82215173_unlace
vendace1357363vendace
vintage11128143vintage
vivace1436553vi_vace
wannabe1234533wannabe
wince105220883wi_n_ce
windage1237933windage
winnable13156983winnable
winnock1643893winnock
yince105214253yi_n_ce
zincate1838533zincate
zingare1737143zingare

Search took 8 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 Limit1340271917.31318327.2
3Display Results1911910.0762513.2
 (SQL Overall)1786911917.79522923.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.