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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
griper9411461(None) 
gripe84622961gripe_
griped104114711griped
gripers104011461gripers
gripes94619871gripes
gripey124111201gripey
gripier103210321gripier
gripper124410711gripper
groper94517251groper
riper74328401_riper
arider74717742arider
briber104714042briber
brier74527402bri_er
briner84519042briner
crier74724462cri_er
crimper136510422crimper
cripe95521142cripe_
cripes105120872cripes
crisper113511052crisper
draper94315692draper
drier64423962dri_er
dripper12349222dripper
driver104714492driver
frier85225842fri_er
frizer184011282frizer
gainer74117492gainer
gaiter73819502gaiter
gaper86125122g_aper
gasper94515542gasper
gawper12499692gawper
giber85417702g_iber
gipper114215302gipper
girder84312062girder
giver94921202g_iver
glider84614262glider
goiter74116202goiter
gorier73719372gori_er
grader84919692grader
grainer83714062grainer
grape84824662grape_
grapery13457952grapery
grapes95123122grapes
grapey126012302grapey
grapier103712602grapier
grasper10389782grasper
grater74625432grater
graver105018592graver
grayer106014542grayer
grazer164815762grazer
greyer104510092greyer
gridder10367762gridder
gride75223582gride_
grided95117042grided
grides84422362grides
grief95319782gri_ef
griever1136032griever
grifter113810492grifter
griller84513352griller
grime85021322grime_
grimed104714092grimed
grimes94619032grimes
grimier103210432grimier
grimmer123510092grimmer
grinder93312392grinder
grinner8329232grinner
grip76127022grip__
gripmen1235032gripmen
grippe115310322grippe
gripped13419342gripped
grippers13358122grippers
grippes124810372grippes
grippier1355202grippier
grippy14447762grippy
grips85520132grip_s
gript85126172grip_t
gripy115115252grip_y
grister83915412grister
gritter83913352gritter
grivet103517822grivet
grocer94212142grocer
grope84821612grope_
groped107515052groped
gropers104813852gropers
gropes95220402gropes
grouper104210092grouper
grower104614932grower
guider84313522guider
gulper93410212gulper
gypper14347292gypper
piper96523192_piper
pricer103918292pricer
prier75027762pri_er
primer105118682primer
prizer174714882prizer
proper104319952proper
raper74932752_raper
ricer74726612_ricer
rider65231302_rider
rifer84721982_rifer
rimer75429242_rimer
ripe66038922_ripe_
riped85226432_riped
ripen75619262_ripen
ripes75435772_ripes
ripper103518652_ripper
riser55431052_riser
river85731692_river
roper75431912_roper
sniper84413642sniper
striper94514782striper
trier54328532tri_er
trimer85717152trimer
tripe75425382tripe_
tripes85324872tripes
tripper113711922tripper
triter65120592triter
unriper9188282unriper
viper105017302_viper
wiper105421292_wiper
wrier84521752wri_er
writer94416512writer

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 Filter178691825510.1261418182.5
2DLD Change Limit825511212.73330205.3
3Display Results1211210.0304033.3
 (SQL Overall)1786911212.88961852.2
 
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.