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

129 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
pneuma103526(None) 
pneumas1145101pneumas
enema7612742ene_ma
nema65522522_ne_ma
neum66723082_neum_
neume74414402_neume
neums75414252_neums
pleura837532pleura
puma85424122p__uma
anemia82613573anemia
anima74620073an_ima
apnea73413413apne__a
bema85825253_be_ma
benumb1235773benumb
bregma1134963bregma
caeoma1039033caeoma
cinema1047643cine_ma
derma84918513_derma
douma85817703_douma
duma75524453__duma
edema8610553ede_ma
enemas8812003ene_mas
enemy1059993ene_my
enigma935633enigma
fusuma1134503fusuma
gemma106311773_gemma
genua64614153genu_a
geum75424553_geum_
geums85414113_geums
herma105318883_herma
ileum74512823ileum_
inhuman1265473inhuman
inhume1196583inhume
intima81910013intima
kinema1236013kine_ma
lemma94811033_lemma
louma76213633_louma
luma65527523__luma
mazuma1935603mazuma
nebula857333_nebula
neem67328083_neem_
neems77316293_neems
nemas75321573_ne_mas
neuk87416603_neu_k
neuks96510863_neuks
neumes83112623_neumes
neumic1036853_neumic
neural6311993_neural
neuroma946523_neuroma
noma67529463_n_oma
numb85520613_n_umb
odeum84610543odeum_
odeums9367313odeums
oleum73613323oleum_
oleums8358783oleums
onium73115533onium_
paella8410913paella
pajama17317653pajama
panama104213343panama
pandura1037143pandura
panhuman1544003panhuman
papula103011113papula
parura8310583parura
pea56657243p_e__a
penman10312323p_enman
penna74520203p_enna
pennia84412973pennia
penult8314653penult
penumbra1442523penumbra
penury1148103penury
pepla9312863p_epla
perea75026443p_erea
perm85834633p_erm_
perms95524513p_erms
pieta75421753pie_ta
pileum10399513pileum_
pima85428653p__ima
pineta85815563pine_ta
pinetum1145553pinetum_
pinnula934913pinnula
plasma103810913plasma
plea66830603ple__a
plena75816393ple_na
plenum1039503plenum_
plenums1136533plenums
pleurae945863pleurae
pleural956673pleural
pleuras937413pleuras
plum85122103p_lum_
plumb114514073p_lumb
plume94819463p_lume
plump115315263p_lump
plums94619953p_lums
plumy124213233p_lumy
pneumatic1545833pneumatic
pneumonia1354063pneumonia
poem86225773poe_m_
poems95715553poe_ms
preamp1238993preamp
prehuman1545033prehuman
preman104117453pre_man
prepupa1064023prepupa
presa74319043pre_sa
presume11310303presume
prima95019343p_rima
pruta7314243p_ruta
pseud867043pseu_d
pseudo934713pseudo
pseuds944793pseuds
puja135714923p__uja
pula65129373p__ula
pumas95121563p__umas
pump105726853p__ump
puna65331653p__una
pupa85422813p__upa
pyemia1337553pyemia
pyjama20303483pyjama
regma84612333_regma
rheum1038843rheum_
rheums1135463rheums
rheumy1433353rheumy
smegma1134113smegma
stemma10328133stemma
struma84313273struma
trauma838803trauma
ulema7109713ule_ma
ungula737603ungula
unhuman1264173unhuman
zeugma1842713_zeugma

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.1401276364.3
2DLD Change Limit1127161295.95318934.3
3Display Results1291290.0502580.0
 (SQL Overall)1786911296.14329088.6
 
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.