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

261 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
krimmer1537687(None) 
brimmer13348801brimmer
crimmer133310771crimmer
grimmer123510091grimmer
krimmers16315671krimmers
primmer134310161primmer
rimmer103516031_rimmer
trimmer113610831trimmer
brimmed14386782brimmed
brimmers14287072brimmers
crammer134010962crammer
crimmers14298542crimmers
crimper136510422crimper
dimmer114112612_dimmer
drummer12407502drummer
glimmer12437712glimmer
grimier103210432grimier
grummer12338782grummer
limmer104314792_limmer
primer105118682pri_mer
primmed14388852primmed
rammer103519652_rammer
rimer75429242_ri_mer
rimier83916272_rimier
rimmed114812302_rimmed
rimmers113812882_rimmers
rummer104715482_rummer
shimmer143310872shimmer
simmer104115352_simmer
skimmer15327532skimmer
slimmer114211342slimmer
swimmer14297652swimmer
trimer85717152tri_mer
trimmed12348932trimmed
trimmers12288912trimmers
aglimmer1342343aglimmer
aimer75926823_ai_mer
arider74717743ari_der
armer76924443ar__mer
armiger1036253armiger
briber104714043bri_ber
bridler103811073bridler
briefer1235563briefer
brier74527403bri__er
briner84519043bri_ner
bringer104213353bringer
brinier93613473brinier
brisker134210293brisker
bummer124014103_bummer
chimer135517203chi_mer
clammer134211793clammer
climber13449133climber
crammed143710123crammed
crammers14369353crammers
creamer113714083creamer
cribber13367663cribber
crier74724463cri__er
crime94822693cri_me_
crimes105521583cri_mes
crimped143910763crimped
crimpers14318933crimpers
crimpier14287323crimpier
cringer103514243cringer
crisper113511053crisper
critter94113033critter
crumber13339643crumber
crummier1435603crummier
cummer124414593_cummer
dammer114317933_dammer
dimer85625603_di_mer
dimmed124110323_dimmed
dimmers123811563_dimmers
drammed13378073drammed
dreamer104110843dreamer
drier64423963dri__er
drifter11348703drifter
driller84311883driller
drinker12349483drinker
dripper12349233dripper
driver104714493dri_ver
drummed13306323drummed
drummers13316163drummers
emmer94314463__emmer
epimer10109153epi_mer
filmer114112403_filmer
firmer114712443_firmer
framer114817443fr_amer
frier85225843fri__er
friller104111743friller
frisker14389273frisker
fritter103912773fritter
frizer184011283fri_zer
frizzer18446893frizzer
gammer1112318333_gammer
gimme102411343_gimme_
gimmes113010903_gimmes
glimmers13396153glimmers
glummer12417983glummer
grammar12406893grammar
gramme114210333gramme_
grammes123611323grammes
gridder10367763gridder
griever1136033griever
grifter113810493grifter
griller84513353griller
grimacer1363963grimacer
grime85021323gri_me_
grimed104714093gri_med
grimes94619033gri_mes
grimmest13286293grimmest
grinder93312393grinder
grinner8329233grinner
griper94114613gri_per
gripier103210323gripier
gripmen1235033gripmen
gripper124410713gripper
grister83915413grister
gritter83913353gritter
grommet12268453grommet
groomer10399873groomer
grummet12298873grummet
gummer114615453_gummer
hammer138120033_hammer
hemmer134112643_hemmer
hummer133615273_hummer
jammer174014133_jammer
jimper17389863_jimper
kaiser103610373kai_ser
keister113011573keister
kicker114116183k_icker
kidder123811093k_idder
kier86526803k_i__er
killer104917953k_iller
kilter103714343k_ilter
kinder113716843k_inder
kipper143414213k_ipper
kirkmen1232923kirkmen
kismet123414623k_ismet
kisser104212453k_isser
kiter95523213k_i_ter
klezmer2231933klezmer
klister113410643klister
knifer13598563kni_fer
knitter11348133knitter
krater104014313kr_ater
kreuzer2032353kreuzer
krises105016083kri_ses
kroner104612573kr_oner
kruller1145153kruller
kummel14266173k_ummel
limber104316793_limber
limier83518723_limier
limmers113413083_limmers
limner84112873_limner
limper104117853_limper
lorimer937753lori_mer
maimer104514593mai_mer
mammer94218863_mammer
mimer94825763_mi_mer
mummer93614543_mummer
nimmed11368573_nimmed
ormer75218373or__mer
plummer13298523plummer
premier113515633premier
pricer103918293pri_cer
pricier113313113pricier
pricker154013413pricker
prier75027763pri__er
prime96525603pri_me_
primed115118913pri_med
primero11368923pri_mero
primers114215673pri_mers
primes104225263pri_mes
primmest14226693primmest
primped14479153primped
prinker133412743prinker
printer93917303printer
privier122910453privier
prizer174714883pri_zer
rammed113117303_rammed
rammers113715043_rammers
rammier112811023_rammier
reamer84325213_reamer
rhymer14387083_rhymer
ribber103515493_ribber
ribier84414233_ribier
ricer74726613_ri_cer
richer114015043_richer
ridder84015143_ridder
rider65231303_ri_der
riever94811653_riever
rifer84721983_ri_fer
rifler94014263_rifler
rigger85616713_rigger
rime65138883_ri_me_
rimed84826373_ri_med
rimers84522553_ri_mers
rimes75634543_ri_mes
ringer74526063_ringer
rinser64317213_rinser
rioter64817283_rioter
riper74328403_ri_per
ripper103518653_ripper
riser55431053_ri_ser
risker105414493_risker
ritter63822423_ritter
river85731693_ri_ver
roamer84715163_roamer
romper104213683_romper
roomer84718633_roomer
rummers113513653_rummers
rummier11309563_rummier
scammer133611973scammer
scrimper1455753scrimper
scummer13398753scummer
shammer144613143shammer
shimmed15338583shimmed
shimmers15269413shimmers
shimmery18265253shimmery
shrimper1544413shrimper
simmers113314613_simmers
simper103616293_simper
skimmed16306053skimmed
skimmers16296463skimmers
slammer113913033slammer
slimier93212013slimier
slimmed12368473slimmed
slimmers12369633slimmers
slummer113711203slummer
spammer133410433spammer
stammer116013343stammer
stemmer113210183stemmer
strummer1234783strummer
summer104017713_summer
swimmers15276693swimmers
swimmier15174313swimmier
thrummer1542933thrummer
timber104012683_timber
timer75626043_ti_mer
trammed123810713trammed
trammel11357663trammel
tramper113812163tramper
tricker134615523tricker
trier54328533tri__er
trifler103912153trifler
trigger9329163trigger
triller74215893triller
trimers94615143tri_mers
trimeter10310083trimeter
trimmest12227023trimmest
tripper113711923tripper
triter65120593tri_ter
trommel11315363trommel
tsimmes1133673tsimmes
tzimmes2033063tzimmes
whimper17297723whimper
wrier84521753wri__er
wringer113612453wringer
writer94416513wri_ter
writher134010853writher
yammer133713183_yammer

Search took 7 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.1431249587.4
2DLD Change Limit1340272616.46620728.0
3Display Results2612610.0962718.8
 (SQL Overall)1786912616.70526650.4
 
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.