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

159 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
grigri83385(None) 
grigris934091grigris
grig65424772grig__
grigs75318192grig_s
grugru842932grugru
ariary94114203ariary
aright103817663aright
ariosi64313033ariosi
briar75718153briar_
briard94311293briard
briars84814823briars
briary114912003briary
brier74527403brier_
briers85319733briers
briery114510773briery
brig76528033brig__
bright124215923bright
brigs85823223brig_s
cirri7710723_cirri
crier74724463crier_
criers83918583criers
drier64423963drier_
driers74516733driers
emigre937053emigre
friar85414273friar_
friars93812093friars
friary124010093friary
frier85225843frier_
friers94718933friers
frig85424503frig__
friges104116483friges
fright133715243fright
frigid1136923frigid
frigs96019273frig_s
garigue935583garigue
gharri10386163gharri
ghibli1243493ghibli
gig56040753g_ig__
giga66720943g_ig_a
gigas75415583g_igas
gighe10139733g_ighe
gigot74023073g_igot
gigs66631183g_ig_s
gigue71210673g_igue
gird65424993g_i_rd
girl56226553g_i_rl
girn56026863g_i_rn
giro55828633g_i_ro
girt56646423g_i_rt
goitre7349003goitre
gorier73719373gorier_
grego7310523greg_o
gregos847533gregos
greige847203greig_e
greiges937733greiges
grid65829613gri__d
gride75223583gri_de
grided95117043grided
grides84422363grides
grids75321393gri_ds
grief95319783gri_ef
griefs10418723griefs
grieve1047243grieve
griff124416463gri_ff
griffe13438093griffe
griffin1434513griffin
griffs13398993griffs
grift95924463gri_ft
grifts104511683grifts
grill64617893gri_ll
grille74315743grille
grills74314803grills
grilse7399503grilse
grim76929423gri__m
grime85021323gri_me
grimed104714093grimed
grimes94619033grimes
grimly12459933grimly
grimy114312603gri_my
grin55733723gri__n
grinch1238473grinch
grind75917563gri_nd
grinds84511843grinds
gringa838553gringa
gringas938043gringas
gringo838643gringo
gringos936673gringos
grins65427223gri_ns
griot65328413gri_ot
griots74713643griots
grip76127023gri__p
gripe84622963gri_pe
griped104114713griped
griper94114613griper
gripers104011463gripers
gripes94619873gripes
gripey124111203gripey
grippe115310323grippe
grippy14447763grippy
grips85520133gri_ps
gript85126173gri_pt
gripy115115253gri_py
griskin1236013griskin
grisly104310583grisly
grison7310103grison
grist65529873gri_st
grists74716483grists
grit55247243gri__t
grith95520373gri_th
griths105211653griths
grits65529583gri_ts
gritty10338403gritty
grivet103517823grivet
grog65923343grog__
groggy1234803groggy
grogram1147073grogram
grogs76319413grog_s
grugrus941993grugrus
guiro63712093gui_ro
gyri85415153g__yri
libri74610113_libri
liri45128253_li_ri
maigre9309163maigre
miri66730373_mi_ri
onagri754963onagri
oribi7311093ori_bi
origami1045453origami
origan7310693origan
origin7311033origin
priapi1037923priapi
prier75027763prier_
priers84521193priers
prig75924873prig__
prigs85219703prig_s
primi95017403pri_mi
prior74316173prior_
priors83914483priors
priory114110263priory
ragi56032283_rag_i
rig46748123_rig__
right94430503_right
rigid7913893_rigid
rigor62714053_rigor
rigors72813713_rigors
rigs55137593_rig_s
rishi8311253_rishi
tragi64717173trag_i
trier54328533trier_
triers64321523triers
trig55528163trig__
trigly103810943trigly
trigo65716053trig_o
trigon74513103trigon
trigos74214173trigos
trigram1077763trigram
trigs65423063trig_s
urari54619963ur_ari
wrier84521753wrier_
wright133713513wright

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127161595.61020092.0
3Display Results1591590.0463456.5
 (SQL Overall)1786911595.77930920.7
 
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.