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

81 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
pyjama2030348(None) 
pajama17317651pajama
pyjamas21263521pyjamas
pajamas18278152pajamas
panama104213342panama
agama85815573_agama
ama510853303___ama
asrama839193asrama
byname13256363byname
cyma116715843cy__ma
drama85117413_drama
dynamo1274163dynamo
gama77035513__gama
grama85620283_grama
jam126942523__jam_
jamb155523853__jamb
jams135231073__jams
java147316643__java
jicama1734873jicama
lama66635293__lama
llama799893_llama
mama86231583__mama
myoma1239273my_oma
myxoma2043943myxoma
nyala836823ny_ala
paca85132243p__aca
pajamaed2042623pajamaed
palapa10310673palapa
pam77858393p__am_
pampa114913423p__ampa
pams85641763p__ams
panada94113053panada
panamas113112753panamas
papa85827143p__apa
papaya1337503papaya
para65242173p__ara
paramo102614643paramo
pataca10311193pataca
patamar1147093patamar
picara10311903picara
pima85428653p__ima
pinata83817213pinata
pirana8713263pirana
piraya1167713piraya
pitaya1186603pitaya
plasma103810913plasma
playa105812943p_laya
plaza164311063p_laza
pneuma1035263pneuma
posada937163posada
praam94815613praam_
praams10459643praams
prajna1535073prajna
pram85733493p_ram_
prams96125513p_rams
preamp1238993preamp
prima95019343p_rima
puja135714923puj__a
pujah17478543puja_h
pujahs18404943pujahs
pujas145513323puja_s
puma85424123p__uma
purana8712933purana
pya87023753py___a
pyaemia1445733pyaemia
pyas96225703py_a_s
pyemia1337553pyemia
pygmy16334223py_gmy
pyramid1547503pyramid
pyran10514473pyra_n
pyrans11411063pyrans
pyrola1139003pyrola
pyuria1136953pyuria
squama1736533squama
tarama8412723tarama
ulama7711473_ulama
unjam1448723unjam_
unjams1555703unjams
yam87448993_y_am_
yams95330733_y_ams
zygoma2143493zygoma

Search took 10 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.1401276364.3
2DLD Change Limit112716819.01612501.8
3Display Results81810.0461760.9
 (SQL Overall)178691819.20219418.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.