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

138 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
cobbs11501399(None) 
cobb106422001cobb_
cobby145516411cobby
cobs87043141co_bs
combs116122961combs
bibbs84911582bibbs
bobby114814662bobby
bobs86340652bo_bs
bombs115818822bombs
boobs96221992boobs
cabby145314562cabby
cabobs124311892cabobs
cabs86739422c_abs
carbs96031462carbs
chubs125412622chubs
clubs95415102clubs
coals76129602coals
coats75635002coats
cob710258752co_b_
cobber124116842cobber
cobbers134114752cobbers
cobble123615262cobble
cobbles133814822cobbles
cobia94117512cobia
cobias104014992cobias
coble94823172coble
cobles104622882cobles
cobra95214402cobra
cobras104014192cobras
cobwebs1631932cobwebs
cocas95926572cocas
cocks135227162cocks
cocos95624692cocos
codas84724242codas
codes86247292codes
cods76848102co_ds
coeds85920162coeds
coffs134916302coffs
cogs77340032co_gs
cohos105921852cohos
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
cokes115537192cokes
colas75436772colas
colby124415062colby
colbys13407152colbys
colds85726972colds
coles76055062coles
cols66553082co_ls
colts76633292colts
comas95833002comas
comb106632112comb_
combe116223542combe
combes125321732combes
combo114519432combo
combos125316612combos
comes97246992comes
comps115526052comps
cones76457422cones
conks115525702conks
conns75024232conns
cons66057692co_ns
conus76726532conus
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coombs124210192coombs
coons76737282coons
coops96229642coops
coos67456492co_os
coots75636842coots
copes97747102copes
cops86751372co_ps
corby125018532corby
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442co_rs
cos510270392co__s
coses76949492coses
coss66143492co_ss
costs77231142costs
cotes76347842cotes
cots68054842co_ts
coups95522472coups
coves105539172coves
cowls106922212cowls
cows97046642co_ws
coxes145430862coxes
coys97537242co_ys
cozes166033242cozes
crabs95421392crabs
cribs94516752cribs
cubby145212122cubby
cubebs12508682cubebs
cubes95028162cubes
cubs85832382c_ubs
curbs94821652curbs
dobby136013632dobby
ebbs82411992_ebbs
fobs96034272fo_bs
forbs105720802forbs
gobos86219382gobos
gobs76935572go_bs
hobby155913732hobby
hobos106321352hobos
hobs97038982ho_bs
jibbs16609742jibbs
jobs136529432jo_bs
kobos115616892kobos
kobs105831082ko_bs
lobby125113922lobby
lobes75331002lobes
lobos75921842lobos
lobs66441082lo_bs
mobs85737372mo_bs
nobby125513462nobby
nobs66436902no_bs
obas65730932_obas
obes66036832_obes
obis66226842_obis
orbs66626252_orbs
robes75133302robes
robs65837872ro_bs
sibbs96211902sibbs
sobas74424252sobas
sobs64941752so_bs
sorbs75022102sorbs
tombs97818732tombs
wombs125813342wombs
yobbo1237872yobbo
yobbos1335962yobbos
yobs96028082yo_bs

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 Filter178691538000.0961861364.6
2DLD Change Limit538001386.3268504.6
3Display Results1381380.0761815.8
 (SQL Overall)1786911386.49827499.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.