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

125 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
stampede1332616(None) 
stamped124812811stamped_
stampeded15343921stampeded
stampeder14304341stampeder
stampedes14315181stampedes
scamped144711962scamped_
stampeders15233202stampeders
stamper113714402stampe_r
stampers124211602stampers
stapedes11197752sta_pedes
stomped124110532stomped_
stumped124210152stumped_
swamped15498442swamped_
tamped114317042_tamped_
abampere1442853abampere
amped104820513__amped_
ampere10514413__ampere
camped134720233_camped_
champed174111483champed_
clamped144012043clamped_
cramped144712183cramped_
damped124315583_damped_
impede11469623__impede
lamped114017543_lamped_
ramped114617903_ramped_
restamped1444433restamped_
sample104215013s_amp_le
sampled123410793s_ampled_
sapped114422013s_apped_
scalped124411993scalped_
scammed14479543scammed_
scamper134613163scampe_r
scampered1635233scampered
scamperer1544623scamperer
scampers143611033scampers
scaped115519553sca_ped_
scarped124314403scarped_
seamed94823883seam_ed_
shamed125120213sham_ed_
shammed153911423shammed_
shaped125020103sha_ped_
sharped134112053sharped_
siamese936503siam_ese
skimped16256223skimped_
slammed123511103slammed_
slapped123511843slapped_
slumped123710153slumped_
snapped124611203snapped_
soaped95817973soa_ped_
spammed14348523spammed_
stabbed123510373stabbed_
stabled103514953stabled_
stacked143416123stacked_
stade64825303sta___de
staffed14298283staffed_
staged84521563sta_ged_
stagged104212083stagged_
stained84215343stained_
staked114621943sta_ked_
staled74728103sta_led_
stalked123811173stalked_
stalled83515683stalled_
stamen84115943stam_e_n
stamened1137633stam_ened
stamens93411483stam_ens
staminode1242653staminode
stammel11607533stamme_l
stammels12495563stammels
stammer116013343stamme_r
stammered1444643stammered
stammerer1344063stammerer
stammers123611523stammers
stamp95217363stamp___
stampeding1642983stampeding
stamping133310963stamping
stampless1334543stampless
stamps105614023stamp__s
standee83514513stande_e
staned74824643sta_ned_
stanged94113843stanged_
stapes85028733sta_pe_s
staple84415823sta_p_le
stapled103613703stapled_
stared75429873sta_red_
starred85013453starred_
started84217323started_
starved114911573starved_
stashed113812493stashed_
stated75427833sta_ted_
statued8459893statued_
staved103918053sta_ved_
stayed104817273sta_yed_
steamed103712143steam_ed_
steeped103412283steeped_
stemmed12278153stemmed_
stepped123210053stepped_
stimied10310623stimied_
stiped94517073st_iped_
stomper114111233stompe_r
stompers123610043stompers
stooped103813833stooped_
stoped94721013st_oped_
stopped124512203stopped_
strapped1357823strapped_
striped105214363striped_
stummed12348553stummed_
stumpage1343303stumpage
stumper113610093stumpe_r
stumpers12318313stumpers
stymied1335663stymied_
swamper14349313swampe_r
swampers15317473swampers
swapped15429143swapped_
tamed85528513_tam_ed_
tamper104618513_tampe_r
tampered13279463_tampered
tamperer12248893_tamperer
tampers113516743_tampers
taped85327423_ta_ped_
tapped113820053_tapped_
temped113912893_temped_
tramped124312433tramped_
tumped114216233_tumped_
unstamped1454603unstamped_
vamped144211013_vamped_

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.420425454.8
2DLD Change Limit1461621257.83018666.9
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.29621539.4
 
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.