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

140 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
camber12441847(None) 
amber94523201_amber
caber95126831ca_ber
cambers134017431cambers
camper124722211camper
chamber164011051chamber
clamber133311731clamber
comber125118501comber
cumber124016701cumber
lamber104418491lamber
ambeer104511592_ambeer
ambers104519562_ambers
ambery133811122_ambery
ambler104916442_ambler
ameer75618982_ameer
barber104419322barber
bomber125014652bomber
cabbed135416262cabbed
cabers105023902ca_bers
cabler104519172cabler
cabmen123610652cabmen
cadger105013892cadger
cager85229222ca_ger
cagier93715932cagier
cahier113615772cahier
cakier123115242cakier
caliber1139732caliber
calker124917082calker
caller85125482caller
calmer105216932calmer
cambered15128992cambered
cambia124913142cambia
came87648752cam_e_
camel96822802cam_el
cameo95924992cam_eo
camera10313672cam_era
cames97047312cam_es
camlet104426582camlet
camped134720232camped
campers134220282campers
campier133313272campier
cancer104220922cancer
caner75334772ca_ner
canker124422522canker
canner84625982canner
canoer85121072canoer
canter85230112canter
caper94831622ca_per
capper124421982capper
carder94524182carder
career85822242career
carer74942332ca_rer
carper104923632carper
carter84932272carter
carver114420142carver
caster85232572caster
cater74840702ca_ter
causer84117782causer
caver105629062ca_ver
chambers173410612chambers
chamfer17399852chamfer
champer163813402champer
clabber134210112clabber
clambers144211282clambers
clammer134211792clammer
clamper134012992clamper
climber13449132climber
clumber134011442clumber
cobber124116842cobber
combe116223542combe_
combed135516542combed
combers134516612combers
combes125321732combes
comer95832692com_er
crabber133810732crabber
crambe1239072crambe_
crambes1339952crambes
crammer134010962crammer
crumber13339642crumber
cuber95222532c_uber
cumbers134515392cumbers
cummer124414592cummer
curber104517052curber
cyber124910382c_yber
dabber114816962dabber
dammer114317932dammer
damner95213432damner
damper114117752damper
dauber94112012dauber
dumber114414172dumber
ember95516792_ember
fabber134814112fabber
gabber114916602gabber
gambe106219212gambe_
gambes116318312gambes
gambier124711962gambier
gambir11509752gambir
gambler123612682gambler
gamer84928942gam_er
gamier93617932gamier
gammer1112318332gammer
hammer138120032hammer
hamper134518652hamper
jabber173713642jabber
jambe165314752jambe_
jambed184811402jambed
jambes175914052jambes
jammer174014132jammer
lambed115614782lambed
lambers113817102lambers
lambert113617112lambert
lambier113611632lambier
lamer75233702lam_er
limber104316772limber
lumber103817772lumber
mammer94218862mammer
mamzer19459832mamzer
member12258852member
nabber104913542nabber
namer75622102nam_er
number103913222number
omber95316432_omber
pamper124316662pamper
rambler113313262rambler
rammer103519652rammer
saber75330242sa_ber
sambar103914162sambar
sambur10469502sambur
scammer133611972scammer
scamper134613162scamper
somber103713992somber
taber73825822ta_ber
tambur10358712tambur
tamer75230102tam_er
tamper104618512tamper
timber104012672timber
umber94617582_umber
vamper134212652vamper
yabber136111832yabber
yammer133713182yammer

Search took 5 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.1231452772.4
2DLD Change Limit825511403.83021553.8
3Display Results1401400.0304666.7
 (SQL Overall)1786911403.98344863.4
 
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.