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 “palikars” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

84 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
palikars144508(None) 
palikar1335451palikar_
alegars838933_alegars
alias55834603_ali_a_s
alidads936293_alidads
aliners74717723_aliners
aliyahs13395323_aliyahs
aliyas93911803_aliya_s
altars64518153_al_tars
balisaurs1143093balisaurs
balkers134915723bal_kers
bolivars1344973bolivars
calamars1238133calamars
calcars11312653cal_cars
calibers1238523calibers
calipers1249443calipers
calkers134414693cal_kers
caviars1238623cavi_ars
daikers124010313da_ikers
halakahs18426633halakahs
kalians11310183kali_ans
lashkars1543673lashkars
liars54723163__li_ars
lidars7310783__lidars
likers104620913__likers
makars124612633ma__kars
malars85020683mal__ars
packers153818893pa_ckers
paiks114719853pa_ik__s
paillard1146263paillard
paillards1244983paillards
pairs75325833pa_i__rs
paisans93614753pa_isans
paisas84317493pa_isa_s
palabras1267353palabras
palais8420423pal__ais
palapas11311493palapa_s
palatals1037773palatals
palavers1337993palavers
paleways1645833paleways
palier85023563pali_er_
palings103915823pali_ngs
palisade1145833palisade
palisades1245613palisades
pallors9314363pal_lors
palmar104113463pal_mar_
palmary14338553pal_mary
palmers113513623pal_mers
palmyras1544033palmyras
palookas1443843palooka_s
palters94021683pal_ters
paniers94717333pani_ers
paprikas1643853paprika_s
pariahs123812343pari_ahs
parians93519733pari_ans
parkas125018023pa_rka_s
parkers133816873pa_rkers
patamars1246843patamars
patinas96318523patina_s
paviors1237603pavi_ors
paviours1343613paviours
pavisers13387443pavisers
pelicans1238093pelicans
pikas114218093p__ika_s
pikers124717393p__ikers
pillars9313493pil_lars
plaiters103512633plaiters
pliers84715153p_li_ers
plinkers14309393p_linkers
polars84419353pol__ars
policers12259993policers
polkas1239103pol_ka_s
pulsars9358913pul_sars
railcars1045313railcars
salinas73116093salina_s
salivary1444733salivary
salivas10309603saliva_s
shikars1436183_shikars
talars66021683tal__ars
talkers113513213tal_kers
talukas11316213taluka_s
valkyrs1732163val_kyrs
walkers143411473wal_kers
zaikais2042913za_ikais

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 Filter1786911461620.436409841.7
2DLD Change Limit146162847.67019056.3
3Display Results84840.0461826.1
 (SQL Overall)178691848.15221919.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.