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

82 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
shrimpier164306(None) 
scrimpier1554241scrimpier
shrimper1544411shrimp_er
crimpier14287322_crimpier
scrimper1455762scrimp_er
shriekier1652962shriekier
shrimped1634212shrimp_ed
shrimpers1633812shrimp_ers
shrimpiest1743322shrimpiest
shrimping1734062shrimping
skimpier1634292s_kimpier
stripier1058862stri_pier
chippier17297673ch_ippier
chirpier15276303ch_irpier
chromier1538033chrom_ier
crampier14288903_crampier
crimper136510423_crimp_er
crispier12297253_crispier
drippier1385043_drippier
frumpier1534173_frumpier
gimpier12247943__gimpier
grimier103210433_grim_ier
gripier103210323_gri_pier
grippier1355203_grippier
grumpier1334803_grumpier
hempier14319003_h_empier
hippier143212103_h_ippier
humpier143110723_h_umpier
rimier83916273__rim_ier
schlumpier1941473schlumpier
scrappier1544423scrappier
scrimped1555313scrimp_ed
scrimpers1554643scrimp_ers
scrimpiest1643743scrimpiest
scrimpily1842553scrimpily
scrimping1634953scrimping
scrimpit1444183scrimpi_t
scripter12137783scri_pter
shiftier1436343sh_iftier
shimmer143310873sh_im_mer
shimmied16294983sh_immied
shimmies15287803sh_immies
shinier104113143sh_i_nier
shipper143514043sh_i_pper
shirtier1137943sh_irtier
shittier1137313sh_ittier
shrieker15265653shri_eker
shriller1136823shri_ller
shrimp13478773shrimp___
shrimplike2181553shrimplike
shrimps14516753shrimp__s
shrimpy17415403shrimp__y
shrinker15236363shri_nker
shriver134712193shri__ver
shrubbier1642193shrubbier
shtickier1843163shtickier
simper103616293s__imp_er
simpler112910863s__impler
sirupier1034303sir_upier
slimier93212013s_lim_ier
slimpsier1343023s_limpsier
slimsier1085213s_limsier
slippier1256533s_lippier
snippier1255793s_nippier
spriggier1343843spriggier
springier1236023springier
strappier1345133strappier
stringier1036713stringier
striper94514793stri_p_er
stripper1247123stri_pper
stroppier1364453stroppier
stumpier1255883s_tumpier
swampier1544593s_wampier
swimmier15174313s_wimmier
syrupier1343053syr_upier
thriftier1542853thriftier
thrummier1641793thrummier
trampier12318243_trampier
trippier1246623_trippier
whimper17297723wh_imp_er
whippier18265823wh_ippier
wimpier14248053__wimpier

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 Filter1786911486410.440406115.9
2DLD Change Limit148641826.48322927.8
3Display Results82820.0332484.8
 (SQL Overall)178691826.95625688.8
 
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.