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

136 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
pinto7562575(None) 
into45026151_into
panto76129411panto
pingo87122711pingo
pinko115618251pinko
pinot78737291pinot
pint66963181pint_
pinta75727051pinta
pintos86021291pintos
pints75936221pints
punto75121321punto
spinto8410661spinto
bento75922952bento
bingo86020092bingo
bint67355052bint_
bints76130182bints
canto74931012canto
cento76625172cento
conto76027172conto
dingo74720792dingo
dino56036762din_o
dint56759062dint_
dints67431312dints
ditto65315602ditto
finito9310302finito
fino76034702fin_o
ginzo1539612ginzo
hint77455752hint_
hints87330622hints
info75617352_info
inro45920792_inro
inti46626082_inti
intro54915852_intro
jingo134615212jingo
junto125114562junto
kino86233632kin_o
lento57223392lento
lingo66022112lingo
lino46343382lin_o
lint416266242lint_
lintol6369472lintol
lints57137192lints
linty87126562linty
mint66758072mint_
mints76834042mints
minty106323902minty
ninth8314582ninth
onto46127662_onto
paint75443692paint_
paints85921832paints
painty114714752painty
pant66061262pant_
pantos85222742pantos
pants76536922pants
panty105929302panty
pengo84317592pengo
pent66559072pent_
pesto75723722pesto
petto76021042petto
photo104417232photo
piano76118712piano
picot95031012picot
pieta75421752pieta
piety105817302piety
pilot77435062pilot
pimento1157222pimento
pin57066732pin__
pina65842642pin_a
pinas75434452pinas
pinata83817222pinata
pinch125619302pinch
pine67755722pin_e
pined85935322pined
pines76048862pines
pineta85815562pineta
piney105727502piney
ping75943602pin_g
pingos95317672pingos
pings85830882pings
pinion83815892pinion
pinite8321242pinite
pinitol936682pinitol
pink107039392pin_k
pinkos125313872pinkos
pinks115729382pinks
pinky145823402pinky
pinna75320182pinna
pinny105222062pinny
pinon76024532pinon
pinots85920272pinots
pins65558462pin_s
pintado1096572pintado
pintano998992pintano
pintas85021392pintas
pintle83818262pintle
pintoes95117712pintoes
pinup9612882pinup
piny911838362pin_y
pinyon11459762pinyon
pisco96314982pisco
piso66727572pi_so
piste75824602piste
pistol83313332pistol
piston83515922piston
pistou83211842pistou
pit56471932pi_t_
pita65436442pi_ta
pith95432702pi_th
piton76121582pi_ton
pits66348752pi_ts
pitta75018692pitta
pity96031942pi_ty
pivot106523872pivot
plinth11310452plinth
point75338732point_
pointe84619312pointe
points85618532points
pointy114913282pointy
ponton83217642ponton
potto75320942potto
print74837462print_
prints84320102prints
pronto8313992pronto
punt65747202punt_
puntos85915792puntos
punts75828002punts
punty106021612punty
putto75617662putto
santo56227282santo
spintos939132spintos
tanto55724952tanto
tint46758872tint_
tints56030922tints
unto45824282_unto
vino76128442vin_o
wino75933622win_o

Search took 9 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 Filter178691538001.050170181.9
2DLD Change Limit538001367.0607620.4
3Display Results1361360.266511.3
 (SQL Overall)1786911368.37621333.7
 
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.