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

104 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
grigris93409(None) 
grigri833851grigri_
grigs75318192grig__s
grugrus941992grugrus
arris56824683ar__ris
briards10398553briards
briars84814823briar_s
briers85319733brier_s
brights133710233brights
brigs85823223brig__s
criers83918583crier_s
crisis83716343cri_sis
driers74516733drier_s
emigres1037673emigres
friaries11310083friaries
friars93812093friar_s
friers94718933frier_s
friges104116483frig_es
frights14339623frights
frigid1136923frig_id
frigs96019273frig__s
garigues1034953garigues
gharris11306433gharris
ghiblis1353343ghiblis
gigas75415583g_ig_as
gigots83911953g_igots
gigs66631183g_ig__s
gigues8129003g_igues
girds74816993g_i_rds
girls64518393g_i_rls
girns64516803g_i_rns
giros65722653g_i_ros
girts65423623g_i_rts
goitres8389563goitres
gratis74819243gr_atis
gregos847533greg_os
greiges937733greig_es
grides84422363gri_des
grids75321393gri__ds
griefs10418723gri_efs
grieves1137323grieves
griffes14367923griffes
griffin1434513griffin
griffins1544783griffins
griffs13398993gri_ffs
grifts104511683gri_fts
grig65424773grig___
grilles83715023grilles
grills74314803gri_lls
grilses8319153grilses
grimes94619033gri_mes
grinds84511843gri_nds
gringas938043gringas
gringos936673gringos
grins65427223gri__ns
griots74713643gri_ots
gripers104011463gripers
gripes94619873gri_pes
grippes124810373grippes
grips85520133gri__ps
griskin1236013griskin
griskins1335953griskins
grisons838993grisons
grists74716483gri_sts
griths105211653gri_ths
grits65529583gri__ts
grivets11357973grivets
grogram1147073grogram
grograms1246023grograms
grogs76319413grog__s
grugru842933grugr_u
guiros7389093gui_ros
iris45732553__i_ris
iritis63113733iri_tis
oribis838833ori_bis
origamis1145283origamis
origans839973origans
origin7311033orig_in
origins8310463origins
orris54516553or__ris
priers84521193prier_s
priggish1544683priggish
priggism1444383priggism
prigs85219703prig__s
priories10312453priories
priors83914483prior_s
ragis66325603_rag_is
rights104019333_rights
rigid7913893_rig_id
rigorism1145793_rigorism
rigorist949123_rigorist
rigors72813713_rigors
rigs55137593_rig__s
rishis9312453_rishis
tigrish1137573_tigrish
triers64321523trier_s
trigons84312093trigons
trigos74214173trig_os
trigram1077763trigram
trigrams11116353trigrams
trigs65423063trig__s
uraris63817273ur_aris
verdigris1441953verdigris
wrights14318993wrights

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271046.90619407.3
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.35924282.0
 
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.