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

94 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
pampeans144470(None) 
pampean1335541pampean_
dampens12348562dampe_ns
paeans85118262pa__eans
pampas124913992pamp_a_s
pamperos14306692pamperos
pampers133615932pampe_rs
sampans112411002samp_ans
tampans113310982tamp_ans
amens75624843_am_e_ns
amperes11313983_amperes
appeals11378673_appeals
appears11308953_appears
arpens84814823_arpe_ns
aspens85013353_aspe_ns
bemeans1148733bem_eans
campers134220293campe_rs
campions143511293campions
capelans1238013ca_pelans
captans111612053ca_ptans
damans94715983dam__ans
dampen114310593dampe_n_
dampers123915693dampe_rs
demeans1039713dem_eans
gamelans11115843gamelans
hampers143616953hampe_rs
happens14359173happe_ns
japans1539823ja_p_ans
kamseens1442823kamseens
lampads12477623lamp_ads
lampas106615953lamp_a_s
lampers113817333lampe_rs
lampions12277973lampions
lampoons12266873lampoons
lumpens11298263lumpe_ns
means75831233__m_eans
paean77222723pa__ean_
paeons83915523pa__eons
paesans93312693pa_esans
pagans95717923pa__gans
pageant10312783pa_geant
pageants1136693pa_geants
paisans93614753pa_isans
pampa114913423pamp_a__
pamper124316663pampe__r
pampered15229233pampered
pamperer14228333pamperer
pamperers15236863pamperers
pampering1638383pampering
pampero13328093pampe_ro
pangens103112063pange_ns
papains11312363pa_pains
papas94927493pa_p_a_s
papaws13419113pa_p_aws
papers105125323pa_pe_rs
paphians1545593paphians
parians93519733pa_rians
parmesans1344103parmesans
partans94418283pa_rtans
pasterns104112623pasterns
patens84820863pa_te_ns
pattens95414923patte_ns
patterns10439943patterns
paupers114311073paupe_rs
pavans115715593pa__vans
pawpaws1732823pawp_aws
peans75437643___peans
pemicans1447033pemicans
pigpens1235503pigpe_ns
playpens1534073plaype_ns
plumpens14304953plumpe_ns
pompano1345203pomp_ano
pompanos1445243pomp_anos
pompons1338553pomp_ons
preplans1249613preplans
proteans102811543proteans
pumpers133113673pumpe_rs
pumpkins1843853pumpkins
rampant11312173ramp_ant
rampions12248023rampions
salpians1036763salpians
sampan102511893samp_an_
spalpeens1341843spalpeens
speans85417143__speans
taipans9269553taip_ans
tameins9311413tam_eins
tampan102512323tamp_an_
tampers113516743tampe_rs
tampions12358123tampions
tampons112711563tamp_ons
tarpans92513533tarp_ans
tympans14236813tymp_ans
vampers143111623vampe_rs
yamens114010823yam_e_ns

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 Filter1786911461620.406440125.6
2DLD Change Limit146162947.34319904.9
3Display Results94940.0303133.3
 (SQL Overall)178691947.77922970.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.