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 “sprig” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
sprig8561774(None) 
prig75924871_prig
sprag86418691sprag
sprigs94814771sprigs
spring94526011spring
sprit76736401sprit
sprug85313891sprug
brig76528032_brig
esprit8312842esprit
frig85424502_frig
grig65424772_grig
pig65744972_p_ig
prigs85219702_prigs
prim85132202_prim
prog75729002_prog
rerig64018482rerig
rig46748122__rig
sari45444042sari_
sarin55239252sarin
saris54544952saris
scrag85916172scrag
scrim95419722scrim
scrip96619192scrip
serif84132122serif
serin55434442serin
sering74731812sering
shri76021692shri_
shris84221442shris
shrug94512512shrug
siring75128312siring
sori46039832sori_
soring74731882soring
spail74921552spail
spait75631602spait
spang84919732spang
sparid94016932sparid
sparing104823872sparing
speil75618642speil
speir75315362speir
spic85227432sp_ic
spik105419712sp_ik
spin66231302sp_in
spire75828692spire
spiring103918182spiring
spirit83519922spirit
spirt75032952spirt
spiry105017352spiry
spit65545082sp_it
spiv95917792sp_iv
split75729012split
spoil75818642spoil
sporing104319412sporing
sprags95715822sprags
sprain83614862sprain
sprang95713522sprang
sprat76635972sprat
spray106720062spray
spree74830862spree
sprier84119062sprier
spriggy14374212spriggy
spright132010402spright
springe103913982springe
springs104415922springs
springy13359662springy
sprint84526792sprint
sprite84421772sprite
sprits85122532sprits
spritz174714412spritz
sprue74717632sprue
sprugs94010172sprugs
sprung94610032sprung
spry96819122spr_y
spuing94313362spuing
spying123913252spying
sri35634002s_ri_
sris45434152s_ris
staig65519632staig
stria55723202stria
string75327562string
strip77524332strip
swig85818022s_wig
trig55528162_trig
unrig61711412unrig

Search took 3 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 Filter178691538000.0931921408.6
2DLD Change Limit53800831.95327547.4
3Display Results83830.0461804.3
 (SQL Overall)178691832.09285416.3
 
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.