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

175 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
grim7692942(None) 
brim85629371brim
glim76026351glim
gram77034581gram
grid65829621grid
grig65424771grig
grime85021321grime
grimy114312601grimy
grin55733721grin
grip76127021grip
grit55247241grit
grum75625081grum
prim85132201prim
rim56052281_rim
trim65329521trim
agria65517142agria
aim57858222_aim
aria46245432aria
arid57642722arid
aril45843022aril
arm58449632ar_m
arum66129032arum
begrim11118332begrim
brie65837902brie
brig76528032brig
brims94721622brims
brin67038192brin
brio65432492brio
bris65539612bris
brit66350152brit
cram85635492cram
crib86323582crib
crime94822692crime
crimp115615802crimp
cris66233432cris
crit65743712crit
dim68146502_dim
dram75832002dram
drib76823262drib
drip76223952drip
drum76521592drum
firm96026462firm
frig85424502frig
frit77044472frit
friz166324342friz
from96923922from
gain56042162gain
gait56150192gait
gam67060062g_am
gaum75726422gaum
gem66840222g_em
germ75428962germ
geum75424552geum
ghi77019882ghi_
ghis85020162ghis
gib66443542g_ib
gid57047282g_id
gie47149552g_ie
gig56040762g_ig
gimp96124052g_imp
gin46055762g_in
gip67645372g_ip
gird65425002gird
girl56226562girl
girn56026872girn
giro55828642giro
girt56646432girt
git46266062g_it
glam76529342glam
glia56423152glia
glib79421442glib
glime85620192glime
glims87417672glims
glom75424382glom
glum75825102glum
gorm75529392gorm
goyim1148602goyim
grab75427612grab
grad66829862grad
grail64622872grail
grain65126252grain
grama85620292grama
gramp106218322gramp
grams85327312grams
gran56335012gran
grat55651282grat
gray85329892gray
gree56641562gree
grew85620262grew
grey85624042grey
gride75223592gride
grids75321402grids
grief95319782grief
griff124416462griff
grift95924462grift
grigs75318192grigs
grill64617892grill
grimed104714092grimed
grimes94619032grimes
grimly12459932grimly
grind75917562grind
grins65427222grins
griot65328412griot
gripe84622962gripe
grips85520132grips
gript85126172gript
gripy115115252gripy
grist65529872grist
grith95520372grith
grits65529582grits
grog65923342grog
groin65521082groin
grok95819682grok
groom85317982groom
grot55942052grot
grow86127302grow
grub77220082grub
grue55825712grue
grume86218162grume
grump105115312grump
guid66022832guid
gum67439532g_um
gym95719062g_ym
gyri85415152gyri_
him86247672_him
irid55927182irid
iris45732552iris
kris86423612kris
maim85831492maim
megrim1178042megrim
mim76048432_mim
nim57142962_nim
ogrism937912ogrism
oxim131114052oxim
pram85733492pram
prig75924872prig
prima95019342prima
prime96525602prime
primi95017402primi
primo95017912primo
primp115615922primp
prims95425932prims
prism94820262prism
prom87631702prom
ram56867272_ram
rem56150042_rem
ria36745512_ria
rib56848042_rib
rid46754642_rid
rif65951572_rif
rig46748132_rig
rime65138892_rime
rims65936312_rims
rimy96621292_rimy
rin36663192_rin
rip56851312_rip
rom59855632_rom
rum56644642_rum
scrim95419742scrim
shim95827862shim
sim56553152_sim
skim105322522skim
slim66631962slim
sri35634002sri_
sris45434152sris
swim96221402swim
tram67034552tram
trig55528162trig
trims75021472trims
trio45233342trio
trip66830392trip
uric63624942uric
vim87437032_vim
whim126220532whim
writ75537912writ

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 Filter178691298721.296137878.9
2DLD Change Limit298721754.0337406.9
3Display Results1751750.0762302.6
 (SQL Overall)1786911755.40533060.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.