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

165 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
grimes9461903(None) 
crimes105521581crimes
glimes94717521glimes
grides84422361grides
grime85021321grime_
grimed104714091grimed
gripes94619871gripes
grumes94415551grumes
primes104225261primes
rimes75634541_rimes
animes84719592animes
arames84622572arames
arises65233802arises
armies85123692armies
begrimes1376512begrimes
berimes115216642berimes
bribes105918532bribes
brides94423512brides
bries74942152bri_es
brims94721622brim_s
brines85028852brines
brises84927612brises
bromes104719762bromes
brumes106417072brumes
chimes134922572chimes
climes104720002climes
cremes104517992cremes
cries75438402cri_es
crime94822692crime_
crimps124613452crimps
cripes105120872cripes
crises84529432crises
dimes85833042_dimes
dries64733672dri_es
drives105117112drives
frames115119862frames
fries85535602fri_es
friges104116482friges
frises94124272frises
frites94922482frites
frizes184015462frizes
games86238552g_ames
gibes84422522g_ibes
gies55641422g_i_es
gimel8313352g_imel
gimels938892g_imels
gimmes113010902gimmes
gimps105915202g_imps
gites65630182g_ites
gives95324872g_ives
glides84518862glides
glime85620192glime_
glimed105312282glimed
glims87417672glim_s
glumes94516812glumes
gnomes93812972gnomes
graces94523492graces
grades84926312grades
gramas94317202gramas
grammes123611322grammes
gramps114114272gramps
grams85327312gram_s
grapes95123122grapes
grates75429892grates
graves104624002graves
grazes164519642grazes
grebes93813612grebes
grees65132472gr_ees
greiges937732greiges
gride75223582gride_
grided95117042grided
grids75321392gri_ds
grief95319782gri_ef
griefs10418722griefs
grieves1137322grieves
griffes14367922griffes
griffs13398992griffs
grifts104511682grifts
grigs75318192gri_gs
grilles83715022grilles
grills74314802grills
grilse7399502grilse
grilses8319152grilses
grim76929422grim__
grimaces1355382grimaces
grimier103210432grimier
grimiest11299822grimiest
grimly12459932grimly
grimmer123510092grimmer
grimmest13286292grimmest
grimness1175992grimness
grimy114312602grim_y
grinds84511842grinds
grins65427222gri_ns
griots74713642griots
gripe84622962gripe_
griped104114712griped
griper94114612griper
gripers104011462gripers
gripey124111202gripey
gripmen1235032gripmen
grippes124810372grippes
grips85520132gri_ps
grists74716482grists
griths105211652griths
grits65529582gri_ts
grivet103517822grivet
grivets11357972grivets
gropes95220402gropes
groves104318102groves
grues65721962gr_ues
grume86218162grume_
grumps114510572grumps
guides84118282guides
guiles73919282guiles
guimpes1245072guimpes
guises74216312guises
irides74519122irides
irises64221172irises
krises105016082krises
limes75636502_limes
mimes95732022_mimes
oximes15107422oximes
prices104524542prices
prides94324182prides
pries74339532pri_es
primas104418102primas
prime96525602prime_
primed115118912primed
primer105118682primer
primers114215672primers
primos104514422primos
primps124711822primps
prims95425932prim_s
primus103712172primus
prises84133172prises
prizes173819812prizes
ribes75530172_ribes
rices75536152_rices
rides66140812_rides
riles55343642_riles
rime65138882_rime_
rimed84826372_rimed
rimer75429242_rimer
rimers84522552_rimers
rims65936302_rim_s
ripes75435772_ripes
rises55244042_rises
rites54442552_rites
rives85336002_rives
slimes84722042slimes
stimes85920572stimes
times75630822_times
tribes85119022tribes
trices84826332trices
tries55742812tri_es
trikes105419492trikes
trimer85717152trimer
trimers94615142trimers
trims75021472trim_s
trines64132562trines
tripes85324872tripes
urines64724122urines
wries85827742wri_es
writes94420332writes

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.360496363.9
2DLD Change Limit825511652.46633475.7
3Display Results1651650.0632619.0
 (SQL Overall)1786911652.88961852.2
 
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.