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

116 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
combes12532173(None) 
bombes124916821bombes
combe116223541combe_
combed135516541combed
comber125118501comber
combers134516611combers
combos125316611combos
combs116122961comb_s
comes97246991com_es
comtes106222811comtes
coombes133810661coombes
bombe115519312bombe_
bombed134113872bombed
bomber125014652bomber
bombers134512592bombers
bombs115818822bomb_s
camber124418472camber
cambers134017432cambers
cames97047312cam_es
coaxes154715632coaxes
cobber124116842cobber
cobbers134114752cobbers
cobbles133814822cobbles
cobbs115013982co_bbs
cobles104622882cobles
cobs87043142co_b_s
codes86247292co_des
cokes115537192co_kes
colbys13407152colbys
coles76055062co_les
colies84837052colies
comae97128422comae_
comakes154413642comakes
comas95833002com_as
comates114123632comates
comb106632112comb__
combat12316752combat
combats13311682combats
combines142814622combines
combo114519432comb_o
combust1338352combust
come87547702com_e_
comer95832692com_er
comers105328082comers
comet95946072com_et
comets105823582comets
comics124015562comics
commas124814572commas
commies133718442commies
comose105016842comose
comous10816502comous
compas125817062compas
comped135919872comped
compel124412892compel
compels133210882compels
compos124818802compos
comps115526052com_ps
compts125216652compts
comte96125472comte_
cones76457422co_nes
conges94928172conges
conies84338592conies
contes84432912contes
cooees85621892cooees
coombe124110092coombe_
coombs124210192coomb_s
copes97747102co_pes
copies104130302copies
copses104922472copses
corbel103715972corbel
corbels113813592corbels
corbies113520112corbies
cores76361852co_res
corses84433462corses
corves115122522corves
coses76949492co_ses
coshes115022782coshes
cosies84932152cosies
cotes76347842co_tes
coupes105022522coupes
coves105539172co_ves
coxes145430862co_xes
cozes166033242co_zes
cozies174521412cozies
cozzes164510892cozzes
crambes1339952crambes
cubes95028162c_ubes
cumber124016702cumber
cumbers134515392cumbers
cymes1210118922cym_es
domes85735562dom_es
gambes116318312gambes
gombos114311092gombos
hombres14369872hombres
homes106938812hom_es
homies114524722homies
jambes175914052jambes
kombus1435522kombus
lobes75331002lo_bes
momes95134472mom_es
nombles113212342nombles
nomes74933122nom_es
obes66036832_o_bes
omber95316432_omber
ombers104214392_ombers
ombres103911132_ombres
pomes94833932pom_es
robes75133302ro_bes
somber103713992somber
tombed113812132tombed
tombs97818732tomb_s
tomes76037382tom_es
wombed14419232wombed
wombs125813342womb_s
zombies2037982zombies
zombis1936272zombis

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.1061685764.2
2DLD Change Limit825511164.70317552.8
3Display Results1161160.0801450.0
 (SQL Overall)1786911164.88936549.6
 
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.