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

177 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
pinwales136796(None) 
pinwale1257841pinwale_
finales104016012fin_ales
gunwales1244732gunwales
inhales10511862_inhales
inwalls1037282_inwalls
pinballs1246932pinballs
pineals93212842pineal_s
pinholes131810662pinholes
pinnaces12268862pinnaces
pinnacles13276042pinnacles
pinnules1036462pinnules
pinocles1248692pinocles
pinoles93418702pin_oles
pintles94118722pin_tles
tinwares1137912tinwares
airwaves1444723airwaves
biennales1143803biennales
bindles104016453bin_dles
binnacles13244583binnacles
binocles1236413binocles
cineoles10109403cineoles
dindles93817243din_dles
dingles93818323din_gles
finagles12237553finagles
finale94116763fin_ale_
finalis103313663fin_alis
finals94316163fin_al_s
finialed1255503finialed
finials103210153finial_s
gingalls1096433gingalls
gingals9109313gingal_s
gunwale1134733gunwale_
impales113311763_impales
inanes62519803_in_anes
incages103013883_incages
incases93615973_incases
indoles83716363_indoles
infalls1038943_infalls
infares10313023_infares
ingates82716913_ingates
ingles74420873_in_gles
inhale9411513_inhale_
inhaled1169333_inhaled
inhaler1068053_inhaler
inhalers1166643_inhalers
inkles103515653_in_kles
inlaces92512903_inlaces
inmates92715783_inmates
innages82911303_innages
insoles73516243_insoles
intakes11310943_intakes
invades11118293_invades
inwall938343_inwal_l
inwalled1275773_inwalled
inwards1138343_inwards
inweaves1445043_inweaves
jingalls1685333jingalls
jingals1588073jingal_s
jingles153816383jin_gles
kinases113511123kin_ases
kindles123614843kin_dles
linages8813173lin_ages
lindanes939173lindanes
lineages979183lineages
linkages1385953linkages
mingles103719003min_gles
mintages111110513mintages
pales75753803p___ales
pancakes1637073pancakes
panicles121010113panicles
pantalet10415903pantalet
pantalets1147673pantalets
pantiles103617153pantiles
pawnages1435313pawnages
paxwaxes1942053paxwaxes
penates93321603pen_ates
pennames12287793pennames
pentacles1338773pentacles
pentanes10316083pentanes
percales12313803percales
petrales10312983petrales
pibals103813083pi_bal_s
pickaxes2344913pickaxes
pickles153215443pi_ckles
picowaves19102893picowaves
picrates122013213picrates
piddles114314273pi_ddles
piebalds1344343piebalds
pieholes13168913pieholes
piffles15368763pi_ffles
pikakes1245823pi_kakes
piles74742613pi___les
pillages113012613pillages
pilules9510623pi_lules
pimples133012423pi_mples
pinangs10267793pin_angs
pinas75434453pin_a__s
pinatas93711503pin_atas
pinball1137933pinbal_l
pinballed1444033pinballed
pinbones1238143pinbones
pinches144117933pin_ches
pineal84817683pineal__
pineapples1351803pineapples
pinenes93416673pin_enes
pineries102419083pineries
pines76048863pin___es
pinfolds1445143pinfolds
pingoes105116523pin_goes
pinhole122010433pinhole_
pinites9319533pin_ites
pinkeyes17335973pinkeyes
pinkies133818263pin_kies
pinkoes135512313pin_koes
pinnace113510313pinnace_
pinnacle12416963pinnacle_
pinnacled14304503pinnacled
pinnae84414643pinna_e_
pinnal84814273pinnal__
pinnas85315513pinna__s
pinnate93613743pinnate_
pinnated11338553pinnated
pinnies93318443pin_nies
pinnule936003pinnule_
pinochles1644863pinochles
pinocle1138143pinocle_
pinole83218783pin_ole_
pinones94717073pin_ones
pintadas11105083pintadas
pintadoes1295253pintadoes
pintados11105993pintados
pintailed1245553pintailed
pintails10310163pintails
pintanos10107553pintanos
pintas85021393pinta__s
pintle83818263pin_tle_
pintoes95117713pin_toes
pinweed1346933pinw_eed
pinweeds1454143pinweeds
pinwheel1642523pinwheel
pinwheels1742313pinwheels
pinworks17106353pinworks
pinworms15115783pinworms
pipages1289423pi_pages
pipals104213643pi_pal_s
pipeages1336423pipeages
pirates93020333pi_rates
pistoles102514723pistoles
pitfalls1345373pitfalls
pizzazes1752513pizzazes
pizzles17329273pi_zzles
presales10315263presales
pungles104013713pun_gles
singles83520433sin_gles
sinkages1386853sinkages
sinuates8310963sinuates
spinages11289293spin_ages
spinals93911863spin_al_s
spindles112710353spin_dles
spinelles1146083spinelles
spinules10249333spin_ules
swales93920763__swales
timbales12227843timbales
tincals93610643tincal_s
tingles83818323tin_gles
tinkles113713923tin_kles
tinware1038603tinware_
unbales92914863_unbales
vinals94716483vin_al_s
vintages12118273vintages
wales86142833___wales
windages1338263windages
windles113518493win_dles
winkles143412773win_kles
wintles103414983win_tles
zincates1937743zincates

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621777.28020077.2
3Display Results1771770.0632809.5
 (SQL Overall)1786911777.74923059.9
 
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.