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

127 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
talar5622538(None) 
alar46340071_alar
malar76424441malar
tala45938051tala_
talars66021681talars
talas55935891talas
taler56034861taler
tatar56122061tatar
tolar55524111tolar
afar76720782_afar
agar58726412_agar
ajar116217702_ajar
ala312463602_ala_
alae45643752_alae
alan46844082_alan
alarm76621422_alarm
alary86123442_alary
alas46358122_alas
altar55520642_altar
atlas55821582atlas
attar56516692attar
balas76937212balas
baler75635272baler
bazar163816002bazar
bolar75123472bolar
calcar10312752calcar
damar84117732damar
filar84819292filar
gala55635162gala_
galah95917622galah
galas65731642galas
galax135314462galax
gazar154612982gazar
gular6314832gular
haar77323492ha_ar
halal85623592halal
haler85033522haler
hilar85418142hilar
jalap143612472jalap
kabar114815552kabar
kalam11315112kalam
lahar83114262lahar
lar37967532__lar
lazar144113642lazar
maar66025052ma_ar
makar115614972makar
malars85020682malars
molar75223092molar
mylar105311532mylar
nala46930392nala_
nalas55528362nalas
navar83912732navar
paler75436932paler
palmar104113462palmar
pilar75221502pilar
polar75623452polar
radar61316722radar
salad65321832salad
salal55425702salal
salary9515212salary
scalar83612432scalar
solar55927342solar
stalag7310022stalag
staler64025822staler
stelar64013862stelar
stylar9358112stylar
tabard9313332tabard
taber73825822taber
tabla73318362tabla_
tablas83716162tablas
tabor75518392tabor
tabular9279762tabular
tahr75217152ta_hr
tailer63823732tailer
tailor63412502tailor
taka87623592taka_
takas95520682takas
taker95229002taker
talaria7412502talaria
talc66226812tal_c
talcs74817182talcs
tale46154162tal_e
talers64628142talers
tales55451372tales
tali46837162tal_i
talk86230092tal_k
talker103916222talker
talks94322692talks
talky126215682talky
tall47240212tal_l
taller63721962taller
talls55133432talls
tally84526862tally
talon55824112talon
taluk94812872taluk
talus55423262talus
tamal73522612tamal
tamari8313382tamari
tamer75230102tamer
tapa65129142tapa_
tapas74627712tapas
taper74829772taper
tapir75917062tapir
tar37570692t__ar
tartar63214752tartar
tatars64619792tatars
tater54138612tater
tawer85223442tawer
taxa116820092taxa_
taxer125019362taxer
tear45242882t_ear
tela45532972tela_
telae54323292telae
thaler94613102thaler
tilak91011552tilak
tiler56131022tiler
tola45236332tola_
tolan55124012tolan
tolars64817922tolars
tolas54532772tolas
tsar47819802t_sar
tzar136315372t_zar
valor83614892valor
valvar12388652valvar
velar85817632velar
volar86917412volar
waler84229262waler

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.1101624463.6
2DLD Change Limit538001271.51635488.1
3Display Results1271270.0304233.3
 (SQL Overall)1786911271.656107905.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.