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

73 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
pyjamas2126352(None) 
pajamas18278151pajamas
pyjama20303481pyjama_
pajama17317652pajama_
panamas113112762panamas
agamas97413453_agamas
amas67746293___amas
asramas938303asramas
bynames14256243bynames
camas96333523__camas
cymas126417883cy__mas
dramas95814663_dramas
dynamos1373853dynamos
gamas85431363__gamas
gramas94317203_gramas
jambs166014623__jambs
jams135231073__jam_s
javas155915423__javas
jicamas1845053jicamas
lamas75532793__lamas
llamas888973_llamas
mamas95930773__mamas
myomas1338303my_omas
myxomas2153913myxomas
nyalas936903ny_alas
pacas96029403p__acas
pajamaed2042623pajamaed
palapas11311493palapas
pampas124913993p__ampas
pams85641763p__am_s
panadas103312213panadas
panama104213353panama_
papas94927493p__apas
papayas1437273papayas
paramos113213513paramos
paras76143043p__aras
patacas11311003patacas
patamar1147093patamar
patamars1246843patamars
picaras11311283picaras
pimas94725103p__imas
pinatas93711503pinatas
piranas9912603piranas
pirayas1277483pirayas
pitayas1286263pitayas
plasmas113010753plasmas
playas114612283p_layas
plazas17409913p_lazas
pneumas1145103pneumas
posadas1037193posadas
praams10459643praam_s
prajnas1635453prajnas
prams96125513p_ram_s
preamps1336613preamps
primas104418103p_rimas
pujahs18404943puja_hs
pujas145513323puj__as
pumas95121563p__umas
puranas9712643puranas
pyaemias1545063pyaemias
pyas96225703py___as
pyemias1436803pyemias
pyramid1547513pyramid
pyramids1645643pyramids
pyrans11411063pyra_ns
pyrolas1239863pyrolas
pyurias1236713pyurias
shamas113717943_shamas
taramas9612703taramas
ulamas8910453_ulamas
unjams1555703unjam_s
yams95330733_y_am_s
zygomas2243413zygomas

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 Filter1786911340270.390458182.1
2DLD Change Limit134027735.97022450.1
3Display Results73730.0302433.3
 (SQL Overall)178691736.39027964.2
 
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.