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

399 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
climber1344913(None) 
clamber133311731clamber
climbed14336981climbed
climbers14318401climbers
clumber134011441clumber
limber104316771_limber
caliber1139732cali_ber
camber124418472c_amber
chamber164011052chamber
chimer135517202chim_er
clabber134210112clabber
claimer11279882claim_er
clambers144211282clambers
clammer134211792clammer
clamper134012992clamper
clicker154111882clicker
climb115413592climb__
climbs12498722climb_s
clime95720892clim_e_
climes104720002clim_es
clinger103812142clinger
clinker133811662clinker
clipper133710322clipper
clobber13378162clobber
clubber13319592clubber
clumbers143910392clumbers
comber125118502c_omber
cribber13367662cribber
crimmer133310772crimmer
crimper136510422crimper
crumber13339642crumber
cumber124016702c_umber
glibber1235162glibber
glimmer12437712glimmer
lamber104418492_lamber
libber104414002_libber
liber74723612_li_ber
limbed114513172_limbed
limbers113614722_limbers
limbier11349092_limbier
limier83518712_limier
limmer104314792_limmer
limner84112862_limner
limper104117852_limper
lumber103817772_lumber
plumber13339982plumber
slimier93212012slimier
slimmer114211342slimmer
slumber113811002slumber
timber104012672_timber
unlimber1243372unlimber
aglimmer1342343aglimmer
aimer75926823_aim_er
aliener71011193aliener
aligner8108303aligner
aliner65621983ali_ner
almner85710723al_mner
amber94523203__amber
bibber94613573_bibber
blabber10418923blabber
blamer104417143blam_er
blimey13468453blim_ey
blinder103912983blinder
blinker134110213blinker
blister94415313blister
blither124812173blither
blitzer18447663blitzer
blubber10399293blubber
bomber125014653_bomber
briber104714043bri_ber
brimmer13348803brimmer
caber95126833c__aber
calibers1238523cali_bers
calibre1136603cali_bre
caliper11410963cali_per
calmer105216933calm_er
cambers134017433c_ambers
camper124722213c_amper
ceiler84013963cei_ler
chambers173410613chambers
chamfer17399853chamfer
champer163813403champer
chicer134513603chi_cer
chider125116053chi_der
chiefer1536863chiefer
chigger1436003chigger
chiller124112183chiller
chimaera1564913chimaera
chimar133911463chim_ar
chimb144813563chimb__
chimbley2063133chimbley
chimbly1974593chimbly
chimbs153910303chimb_s
chime125322593chim_e_
chimed145814833chim_ed
chimera14389263chim_era
chimere144010633chim_ere
chimers144515133chim_ers
chimes134922573chim_es
chimley1785163chimley
chimney1795483chimney
chipper163912583chipper
chirker16429323chirker
chirper14359963chirper
chitter124112963chitter
chomper163810073chomper
cider84723313c_i_der
cimex16119133c_im_ex
cinder94119123c_inder
cipher133710263c_ipher
citer74827323c_i_ter
cither114616683c_ither
clabbers14359893clabbers
clacker153813773clacker
claimed12298833claim_ed
claimers12298743claim_ers
clambered16146123clambered
clamberer15185263clamberer
clammed14369963clammed
clammers143510683clammers
clammier1435843clammier
clamor1049453clam_or
clamorer1236903clamorer
clamour1196323clamour
clamped144012043clamped
clampers143211883clampers
clanger104113493clanger
clapper134011863clapper
claquer18287343claquer
clasher124615513clasher
clasper113811863clasper
classer93614613classer
clatter94014973clatter
claver113816973cl_aver
clavier1239173clavier
clawer114512783cl_awer
clayier1248323clayier
cleaner93712303cleaner
clearer93710823clearer
cleaver124110803cleaver
clever114611533cl_ever
cliche133712453cliche_
cliched153711023cliched
cliches144213743cliches
clicked164112453clicked
clickers163910203clickers
cliffier1633913cliffier
climate11312833climate
climates12311963climates
climax1735653clim_ax
climaxed2043113climaxed
climaxes1944613climaxes
climbing15205973climbing
clincher15347663clincher
cline76428533cli_ne_
clines84926043cli_nes
clinged113310093clinged
clingers113810653clingers
clingier1155843clingier
clinked144011643clinked
clinkers14339833clinkers
clipped14439833clipped
clippers14368833clippers
clique17289193clique_
cliqued19266683cliqued
cliques18309203cliques
cliquey21295693cliquey
cliquier1944223cliquier
clivers123411753cli_vers
clobbers14397513clobbers
clocker153910873clocker
clogger11438803clogger
cloister1037093cloister
clomb115714703clomb__
clomped14398973clomped
cloner84418093cl_oner
closer84918203cl_oser
clouter93511683clouter
clover114617123cl_over
clowder13367933clowder
clubbed14307453clubbed
clubbers14378573clubbers
clubbier1434833clubbier
clubmen1334253clubmen
clumped143610663clumped
clumpier1435583clumpier
clumsier1234733clumsier
clunker13419453clunker
cluster94013323cluster
clutter94211653clutter
clyster12317453clyster
cobber124116843c_obber
coiler84421593coi_ler
coiner84323783coi_ner
coinfer12419393coinfer
cointer93616723cointer
combe116223543c_ombe_
combed135516543c_ombed
combers134516613c_ombers
combes125321733c_ombes
comember1644163comember
comer95832693c_om_er
coombe124110093coombe_
coombes133810663coombes
crabber133810733crabber
crambe1239073crambe_
crambes1339953crambes
crammer134010963crammer
cribbed14407663cribbed
cribbers14306443cribbers
crier74724463cri__er
crime94822693crim_e_
crimes105521583crim_es
crimmers14298543crimmers
crimped143910763crimped
crimpers14318933crimpers
crimpier14287323crimpier
cringer103514243cringer
crisper113511053crisper
critter94113033critter
crumbed14378473crumbed
crumbers14338223crumbers
crumbier1456363crumbier
cuber95222533c__uber
cucumber1642603cucumber
cumbers134515393c_umbers
cummer124414593c_ummer
curber104517053c_urber
cyber124910383c__yber
cylinder1433383cylinder
dibber114614713_dibber
dimer85625603_dim_er
dimmer114112613_dimmer
dumber114414173_dumber
eclipser1242793eclipser
elmier839813el_mier
ember95516793__ember
epimer10109153epim_er
fibber134811933_fibber
fiber104921133_fi_ber
filmer114112403film_er
filmier1237503filmier
flambe13489153flambe_
flambee144210013flambee
flambes14419503flambes
flamer114919123flam_er
flamier123112143flamier
flicker163610623flicker
flier86023403fli__er
flimsier1344133flimsier
flinder11319873flinder
flinger113710503flinger
flipper14389143flipper
flirter10318673flirter
flitter103413903flitter
flivver1633043flivver
flubber14287713flubber
gibber114112863_gibber
giber85417703_gi_ber
glider84614263gli_der
glime85620193glim_e_
glimed105312283glim_ed
glimes94717523glim_es
glimmers13396153glimmers
glimpser1342663glimpser
glister84013343glister
glitter84211803glitter
glummer12417983glummer
grimier103210433grimier
grimmer123510093grimmer
imbed105013633__imbed
jibber174111243_jibber
jiber145115703_ji_ber
jimper17389863_jimper
klister113410643klister
krimmer15376873krimmer
lambed115614783_lambed
lambers113817103_lambers
lambert113617113_lambert
lambier113611633_lambier
lamer75233703_lam_er
libbers113812823_libbers
libel74116103_li_bel
libers84721433_li_bers
licker125222043_licker
lieder74912323_lieder
liefer9529573_liefer
lier45942463_li__er
liever94611863_liever
lifer85822153_li_fer
lifter93814813_lifter
liger65024463_li_ger
liker95627063_li_ker
limb85429373_limb__
limba95414973_limb_a
limbas105313193_limbas
limbeck1744163_limbeck
limbered13158113_limbered
limberer12187043_limberer
limberly1544453_limberly
limbi96513793_limb_i
limbic12528723_limbic
limbo95614803_limb_o
limbos104712133_limbos
limbs96118933_limb_s
limbus105710373_limbus
limby125714063_limb_y
lime66244933_lim_e_
limed85426803_lim_ed
limen75426033_lim_en
limes75636503_lim_es
limey104721043_lim_ey
limiter92710853_limiter
limmers113413083_limmers
limned94811473_limned
limners93311553_limners
limped114817123_limped
limpers113815223_limpers
limpet103518633_limpet
liner55938913_li_ner
linger75225993_linger
linier64423783_linier
linker104321463_linker
linter64625333_linter
lipper104219633_lipper
lisper84114433_lisper
lister64527253_lister
liter54736343_li_ter
lither94520953_lither
litter64324853_litter
liver85132963_li_ver
livier97514593_livier
livyer12426293_livyer
lobber104016593_lobber
lubber104214623_lubber
lumbar103610593_lumbar
lumbers113815913_lumbers
lumper103816653_lumper
maimer104514593maim_er
member12258853_member
mimbar1297483_mimbar
mimer94825763_mim_er
nimbler11358053_nimbler
number103913223_number
omber95316433__omber
plier75221283pli__er
plinker134010963plinker
plumbed14317273plumbed
plumbers14418513plumbers
plumbery17315533plumbery
plumier113510043plumier
plummer13298523plummer
plumper13318773plumper
primer105118683prim_er
primmer134310163primmer
ribber103515493_ribber
rimer75429243_rim_er
rimier83916263_rimier
rimmer103516033_rimmer
scriber113910963scri_ber
scrimper1455753scrimper
shimmer143310873shimmer
simmer104115353_simmer
simper103616293_simper
skimmer15327533skimmer
slabber113311393slabber
slammer113913033slammer
slicer84117603sli_cer
slicker133314533slicker
slider73918363sli_der
slier54827243sli__er
slime74925753slim_e_
slimed94915123slim_ed
slimes84722043slim_es
slimmed12368473slimmed
slimmers12369633slimmers
slimsier1085213slimsier
slinger83413823slinger
slipper113712973slipper
slither104112983slither
slitter73615873slitter
sliver94116593sli_ver
slobber11388903slobber
slubber113010763slubber
slumbers123110273slumbers
slumbery15296043slumbery
slummer113711203slummer
somber103713993_somber
swimmer14297653swimmer
timbers113111833_timbers
timbery14256873_timbery
timbre10328623_timbre
timer75626043_tim_er
trimer85717153trim_er
trimmer113610833trimmer
umber94617583__umber
unlimbers1342583unlimbers
upclimbed1841443upclimbed
whimper17297723whimper

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.1531167915.0
2DLD Change Limit1340273997.25318478.8
3Display Results3993990.1402850.0
 (SQL Overall)1786913997.54623680.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.