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

206 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
tapalos93881(None) 
tapalo839791tapalo_
catalos9414162catalos
napalms1144032napalms
tamales93216142tamales
tamals84116622tamal_s
tampalas1245472tampalas
tapas74627712tapa__s
tepals85415042tepal_s
tupelos936112tupelos
aals49941143_a_al_s
alamos8415003_alamos
analog7159963_analog
analogs82810443_analogs
anglos74413903_anglos
apollos946793_apollos
apolog938903_apolog
apologs1038593_apologs
apos65433823_ap__os
appalls11337743appalls
appals104812943appal_s
apples104315763_apples
atabals938413atabal_s
baals76122703ba_al_s
bacalaos1245863bacalaos
basalts9358963basalts
bayamos1434663bayamos
cabalas113516003cabalas
cabals104020153cabal_s
cacaos104616183caca_os
calos74431903__calos
canals84421663canal_s
capos94826073cap__os
carpals113414623carpal_s
catalo8314853catalo_
cataloes10311643cataloes
catalog1038003catalog
catalogs1148033catalogs
cattalos1037933cattalos
copalms13367543copalms
copals105018943copal_s
dapples1238993dapples
empales112411433empales
enhalos1087533enhalos
galagos938143galagos
gayals1039513gayal_s
gazabos1944453gazabos
halalas104214083halalas
halals95018313halal_s
hallos95425103ha_llos
halos85230253__halos
hamals114816813hamal_s
hapaxes1936593hapaxes
hawalas13348353hawalas
impalas11236953impalas
impales113311763impales
jacales16310323jacales
jacals1539873jacal_s
japans1539823japa_ns
kabalas133911063kabalas
kakapos1243673kakapos
kamalas13339123kamalas
kapas116021733kapa__s
lapels83712043lapel_s
lavabos1235453lavabos
macacos1338083macacos
magalog1144903magalog
magalogs1245243magalogs
maples104819423map_les
masalas9312053masalas
napalm1047263napal_m
napas75924353napa__s
nasals63312463nasal_s
nopales93812523nopales
nopals84914023nopal_s
omphalos1543683omphalos
opals75718353_opal_s
pales75753803__pales
palls74332563__palls
palms94921753__palms
palps94719563__palps
pals66951353__pal_s
papadom1466763papadom
papadoms1575923papadoms
papains11312363papains
papal95820673papal__
papally1437973papally
papas94927493papa__s
papaws13419113papa_ws
papayas1437273papayas
papules112411573papules
papulose1244533papulose
parados103816053parados
paramos113213513paramos
pedalos10329683pedalos
peplos101211543pep_los
pipals104213643pipal_s
polos76129913__polos
qabalas18289503qabalas
rabatos93010893rabatos
ratals64219583ratal_s
robalos937673robalos
sabals84618863sabal_s
salals65120083salal_s
sapajou1643693sapajou
sapajous1744833sapajous
sapsagos1143773sapsagos
sepalous1047523sepalous
sepals85217373sepal_s
spales84728103_spales
spalls84217343_spalls
staples93617213stap_les
tabards10310383tabards
tablas83716163ta_blas
tables84524883ta_bles
taboos83815423ta_boos
tabulis938833tabulis
tackles133816523tackles
tacos77023553t__acos
tadpoles1135953tadpoles
taels56822073ta_el_s
tagalong1042753tagalong
tagalongs1142233tagalongs
tailles72516463tailles
tailor63412503ta_ilor
tailors73212383ta_ilors
tails55634193ta_il_s
taipans9269553taipa_ns
takahes1436173takahes
takas95520683taka__s
talars66021683tala_rs
talas55935893t__alas
talcs74817183t__alcs
tales55451373t__ales
talks94322693t__alks
tallis63319963ta_llis
tallol63612223ta_llol
tallols73311353ta_llols
tallow93714203ta_llow
tallows103313733ta_llows
talls55133433t__alls
talon55824113t__alon
talons64019423t__alons
talus55423263t__alus
tamal73522613tamal__
tamale83717393tamal_e
tamaraos10105883tamaraos
tamaris9413573tamaris
tambalas1237033tambalas
tampala1136613tampal_a
tampans113310983tampa_ns
tangelos935743tangelos
tangles83920043tangles
tangos74216303ta_ngos
tantalous946183tantalous
tantalus836373tantalus
taos45541003t__a_os
tapa65129143tapa___
tapaderos1242373tapaderos
tapeless10218643tapeless
tapers84025813tap_ers
tapes75838603tap__es
taphole1239773taphole
tapholes1339623tapholes
tapirs84113173tap_irs
tapis75028863tap__is
tapises92914013tapises
tappers113416543tappers
tappets113610013tappets
taproom1147963taproom
taprooms1246663taprooms
taproot9412673taproot
taproots1047253taproots
taps66050673tap___s
taramas9612693taramas
taros55640823t__aros
tarpans92513533tarpa_ns
tarsals72512603tarsal_s
tatamis939713tatamis
tatars64619793tata_rs
tattles73616283tattles
tattoos738643tattoos
taxables1734383taxables
taxols13328633taxol_s
teals56234133t_eal_s
telos55424523t__elos
tepal76319583tepal__
tepas76521683tepa__s
thanatos1165113thanatos
tholos94213003t_holos
thralls10299043thralls
ticals83214713tical_s
tipples112811253tipples
topazes1857313topazes
topos75726393top__os
topples113111653topples
totals63115163total_s
trapans92812463trapa_ns
trapballs1344183trapballs
trials64319883trial_s
tupelo836483tupelo_
turacos938623turacos
typal105311153typal__
typos106015813typ__os
zapateos1943113zapateos
zocalos1835393zocalos

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.1401276364.3
2DLD Change Limit1340272067.01619103.1
3Display Results2062060.0802575.0
 (SQL Overall)1786912067.23624694.7
 
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.