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

280 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
tapalo83979(None) 
tapalos938811tapalos
catalo8314852catalo
napalm1047262napalm
papal95820672papal_
tamal73522622tamal_
tamale83717402tamale
tamals84116632tamals
tampala1136612tampala
tapa65129142tapa__
tapas74627712tapa_s
tepal76319582tepal_
tepals85415042tepals
tupelo836482tupelo
typal105311152typal_
aal39058673_a_al_
aals49941143_a_als
alamo7418143_alamo
anal48037523_anal_
analog7159973_analog
anglo65215373_anglo
apace94718383_apace
apart74330673_apart
apo511142123_ap__o
apollo837183_apollo
apolog938903_apolog
appal95315223appal_
appall10379743appall
appals104812943appals
apple94517673_apple
apply125111393_apply
aptly105111813_aptly
atabal839743atabal_
atabals938413atabals
axal116520493_axal_
baal67033113ba_al_
baals76122703ba_als
bacalao1146613bacalao
banal75925993banal_
basal75722283basal_
basalt83519583basalt
bayamo1335603bayamo
cabal95222153cabal_
cabala103516913cabala
cabals104020153cabals
cacao95420003caca_o
calo64936443__calo
canal75428043canal_
canals84421663canals
capable13313363capable
capably1639253capably
capo85829213cap__o
carpal103716253carpal_
carpale113414353carpale
carpals113414623carpals
catalog1038003catalog
catalos9414163catalos
cattalo938423cattalo
copal95621783copal_
copalm125010813copalm
copals105018943copals
dapple1138853dapple
empale102611263empale
enhalo987563enhalo
fatal84819373fatal_
galago838903galago
gayal9312713gayal_
gayals1039513gayals
gazabo1834833gazabo
hadal95518123hadal_
halal85623593halal_
halala94715093halala
halals95018313halals
hallo85127553ha_llo
halo76437323__halo
hamal104623113hamal_
hamals114816823hamals
hapax1739323hapa_x
haply135915063hap_ly
hawala12368913hawala
impala10256933impala
impale102811663impale
jacal14313703jacal_
jacals1539873jacals
japan14411233japa_n
japans1539823japans
kabala124011553kabala
kakapo1143853kakapo
kamala12339963kamala
kapa106021293kapa__
kapas116021733kapa_s
lapel73716683lapel_
lapels83712043lapels
lavabo1135273lavabo
macaco1247853macaco
magalog1144913magalog
maple95521143map_le
masala8311813masala
napa66927263napa__
napalms1144033napalms
napas75924353napa_s
nasal56217593nasal_
nasals63312463nasals
natal53921493natal_
naval85315833naval_
nopal75517103nopal_
nopals84914023nopals
opal66923523_opal_
opals75718353_opals
pal56761673__pal_
pale66055013__pale
pall65039343__pall
palm85331363__palm
palp85828573__palp
palpal104112053palpal_
pals66951353__pals
paly95835533__paly
papa85827143papa__
papacy1547493papacy
papadom1466763papadom
papain10313793papain
papally1437973papally
papas94927493papa_s
papaw125112493papa_w
papaws13419113papaws
papaya1337503papaya
papula103011113papula
papule102212133papule
paramo102614643paramo
pedalo93811153pedalo
pipal95118353pipal_
pipals104213643pipals
polo66236633__polo
pupal97616873pupal_
qabala17399193qabala
rabato83413263rabato
ramal74622243ramal_
raptly11338913raptly
ratal55025113ratal_
ratals64219583ratals
robalo838933robalo
sabal75422483sabal_
sabals84618863sabals
salal55425703salal_
salals65120083salals
sapajou1643693sapajou
sapsago1044303sapsago
sepal77723003sepal_
sepals85217373sepals
spado83713703_spado
spale74929213_spale
spall74919303_spall
staple84415823stap_le
statal61613223statal_
tabard9313333tabard
tabla73318363ta_bla
tablas83716163tablas
table75429603ta_ble
taboo73418093ta_boo
tabuli839363tabuli
tackle123815733tackle
taco67031353t__aco
tadpole1036143tadpole
tael46030713ta_el_
taels56822073ta_els
tagalong1042763tagalong
tail45443653ta_il_
taille63116923taille
tailor63412503ta_ilor
tails55634193ta_ils
taipan82410663taipa_n
taipans9269553taipans
taka87623593taka__
takable13310193takable
takahe1335793takahe
takas95520683taka_s
tala45938053t__ala
talar56225383tala_r
talars66021683talars
talas55935893tala_s
talc66226813t__alc
tale46154163t__ale
tali46837163t__ali
talk86230093t__alk
tall47240213t__all
tallol63612223ta_llol
tallow93714203ta_llow
talls55133433ta_lls
tally84526863ta_lly
talon55824113t__alon
tamable11312853tamable
tamales93216153tamales
tamarao977593tamarao
tamari8313403tamari
tambala1138023tambala
tamely113711953tamely
tampalas1245473tampalas
tampan102512323tampa_n
tampans113310983tampans
tangelo837033tangelo
tangle74019953tangle
tangly104413913tangly
tango66921173ta_ngo
tanto55724943ta_nto
tao38358953t__a_o
tap57663873tap___
tapadero1143193tapadero
tape64538143tap__e
tapeable1238823tapeable
taped85327423tap_ed
taper74829773tap_er
tapers84025813tapers
tapes75838603tap_es
tapeta8310693tapeta
tapetal938273tapetal_
taphole1239773taphole
taping94222393taping
tapir75917063tap_ir
tapirs84113173tapirs
tapis75028863tap_is
tappable1436343tappable
tapped113820053tapped
tapper104419613tapper
tappet103820113tappet
taproom1147963taproom
taproot9412673taproot
taps66050673tap__s
tarama8412733tarama
tardo65321103ta_rdo
tarnal63716503tarnal_
taro46846913t__aro
tarpan82814293tarpa_n
tarpans92513533tarpans
tarsal63315273tarsal_
tarsals72512603tarsals
tartly96014023tartly
tatami839193tatami
tatar56122063tata_r
tatars64619793tatars
tattle64115653tattle
tattoo6310973tattoo
tautly9499503tautly
taxa116820093taxa__
taxable1639073taxable
taxably1936043taxably
taxol124011363taxol_
taxols13328633taxols
taxpaid1743093taxpaid
teal45546503t_eal_
teals56234133t_eals
tepa66021683tepa__
tepas76521683tepa_s
thrall93810293thrall
tical76021493tical_
ticals83214713ticals
tidal64516443tidal_
timpano11235863timpano
tipple103411913tipple
tomato8313453tomato
tonal53724303tonal_
topaz16315323topa_z
topo66932403top__o
topple104411323topple
total55321823total_
totals63115163totals
trapan82412973trapa_n
trapans92812463trapans
trapball1244753trapball
trial54926353trial_
trials64319883trials
tubal75517203tubal_
tupelos936113tupelos
turaco839453turaco
tympano14245283tympano
typable1435883typable
typo95418123typ__o
vagal94613633vagal_
vasal85516293vasal_
zapateo1844593zapateo
zocalo1735803zocalo

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162805.81019400.3
3Display Results2802800.0803500.0
 (SQL Overall)1786912806.26628517.6
 
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.