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

119 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
shrimpers163381(None) 
scrimpers1554641scrimpers
shrimper1544411shrimper_
crimpers14318932_crimpers
scrimper1455762scrimper_
shimmers15269412sh_immers
shippers153012312sh_ippers
shriekers16224422shriekers
shrimped1634212shrimpe_d
shrimpier1643062shrimpier_
shrimps14516752shrimp__s
shrinkers16205382shrinkers
shrivers14419102shri_vers
simpers113014122s__impers
stripers103911592stri_pers
strippers1355772strippers
whimpers18276612wh_impers
brimmers14287073_brimmers
champers173311623ch_ampers
chimers144515143ch_im_ers
chippers173510883ch_ippers
chirpers15358133ch_irpers
chompers17369593ch_ompers
crimmers14298543_crimmers
crimper136510423_crimper_
crispers12309433_crispers
drippers13327943_drippers
gripers104011463_gri_pers
grippers13358133_grippers
hampers143616953_h_ampers
humpers142713523_h_umpers
krimmers16315673_krimmers
limpers113815223__limpers
lorimers1036613lorim_ers
primers114215673_prim_ers
rimers84522553__rim_ers
rimmers113812883__rimmers
rippers114115033__rippers
rompers113412243__rompers
scampers143611033s_campers
scrapers125510533scr_apers
scrappers1545863scrappers
scribers12307963scri_bers
scrimped1555313scrimpe_d
scrimpier1554243scrimpier_
scrimps13517903scrimp__s
scripters13116683scripters
shammers153710843sh_ammers
shapers124016893sh__apers
sharpers133810943sh_arpers
shickers173012823sh_ickers
shiers94921753sh_i__ers
shifters14319863sh_ifters
shikkers14326523sh_ikkers
shimmer143310873sh_immer_
shimmery18265253sh_immery
shiners104015943sh_i_ners
shippens15316803sh_ippens
shipper143514043sh_ipper_
shirkers15319583sh_irkers
shivers133714833sh_i_vers
shoppers153010763sh_oppers
shredders1463713shredders
shrieker15265653shrieker_
shrieks14377673shri__eks
shrieves14297093shrieve_s
shrikes144412393shri_ke_s
shriller1136823shriller_
shrimp13478773shrimp___
shrimpiest1743333shrimpiest
shrimping1734063shrimping
shrimpy17415403shrimp__y
shrines104618693shri_ne_s
shrinker15236363shrinker_
shrivels14376443shri_vels
shriver134712193shri_ver_
shrives134416173shri_ve_s
simmers113314613s__immers
simper103616293s__imper_
sippers113117753s__ippers
skimmers16296463s_kimmers
skippers16318203s_kippers
slimmers12369633s_limmers
slippers123711233s_lippers
snipers93311773s_ni_pers
snippers12299723s_nippers
spriggers13325493spriggers
springers12309983springers
sprinters11329363sprinters
spritzers2043903spritzers
stampers124211603s_tampers
stompers123610043s_tompers
strappers1346743strappers
striders94412123stri_ders
strikers123611293stri_kers
stringers104210643stringers
striper94514793stri_per_
stripes95320573stri_pe_s
stripper1247123stripper_
strivers113911843stri_vers
stroppers1356713stroppers
strummers1333693strummers
strumpets1362893strumpets
stumpers12318313s_tumpers
surmisers1145203surmisers
swampers15317473s_wampers
swimmers15276693s_wimmers
threapers1444773threapers
thrillers1244473thrillers
thrivers14456823thri_vers
thrummers1642413thrummers
thumpers15365713th_umpers
trampers123210393_trampers
trimers94615143_trim_ers
trimmers12288913_trimmers
trippers123210163_trippers
whimper17297723wh_imper_
whippers18329043wh_ippers
whispers16266993wh_ispers

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411197.04621095.8
3Display Results1191190.0631888.9
 (SQL Overall)1786911197.51523777.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.