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

118 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
combed13551654(None) 
bombed134113871bombed
combe116223541combe_
comber125118501comber
combes125321731combes
comped135919871comped
tombed113812131tombed
wombed14419231wombed
bobbed104315832bobbed
bombe115519312bombe_
bomber125014652bomber
bombes124916822bombes
boobed114514872boobed
cabbed135416262cabbed
camber124418482camber
camped134720232camped
chomped17329772chomped
climbed14336982climbed
clomped14398972clomped
coaled95022712coaled
coated94927042coated
coaxed165612512coaxed
cobber124116842cobber
cobbled143411632cobbled
cocked155022562cocked
codded114515302codded
coded95433182co_ded
coed77140542co__ed
cogged116416612cogged
coifed124113062coifed
coiled95123942coiled
coined94523602coined
coked124730692co_ked
coled85540762co_led
comade114415322comade
comae97128422comae_
comb106632112comb__
combat12316752combat
combated1539822combated
combers134516622combers
combined15269182combined
combo114519432comb_o
combos125316612combos
combs116122962comb_s
come87547702com_e_
comedo11359602com_edo
comedy14378232com_edy
comer95832692com_er
comes97246992com_es
comet95946072com_et
commend144010182commend
compel124412892compel
compend144010302compend
compted143813522compted
comte96125472comte_
comtes106222812comtes
coned86040052co_ned
conked135019112conked
conned95119702conned
cooed84534342co_oed
cooeed95917862cooeed
cooked135921362cooked
cooled95224592cooled
coombe124110092coombe_
coombes133810662coombes
cooped114821612cooped
coped105036852co_ped
copied114618572copied
copped135221262copped
corbel103715972corbel
corded105923352corded
cored85044222co_red
corked135020782corked
corned95224522corned
corymbed1842612corymbed
coshed124217552coshed
cosied94819892cosied
costed95623122costed
coted85033852co_ted
couped115019312couped
coved115027372co_ved
cowed115637852co_wed
cowled125218392cowled
coxed154322812co_xed
coyed114623802co_yed
cozied184112162cozied
crumbed14378472crumbed
cubed105519702c_ubed
cumber124016702cumber
curbed114615872curbed
domed95423262dom_ed
dumbed124012082dumbed
embed105014302_embed
fobbed144112612fobbed
gobbed124613882gobbed
hobbed144114302hobbed
homed115425422hom_ed
hotbed123310682hotbed
imbed105013652_imbed
jambed184811402jambed
jobbed184212132jobbed
lambed115614782lambed
limbed114513182limbed
lobbed113114612lobbed
lobed86022132lo_bed
mobbed137112242mobbed
numbed114111442numbed
omber95316442_omber
orbed85516192_orbed
recombed1536722recombed
robbed113415192robbed
robed85323732ro_bed
romped114513652romped
sobbed113516262sobbed
somber103714002somber
sorbed94916522sorbed
tommed113310142tommed
uncombed1536322uncombed

Search took 4 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.343520965.0
2DLD Change Limit825511182.64031269.3
3Display Results1181180.0333575.8
 (SQL Overall)1786911183.01659247.7
 
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.