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

114 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
combe11622354(None) 
bombe115519311bombe
comae97128421comae
comb106632111comb_
combed135516541combed
comber125118501comber
combes125321731combes
combo114519431combo
combs116122961combs
come87547701com_e
comte96125471comte
coombe124110091coombe
bomb106927422bomb_
bombed134113872bombed
bomber125014652bomber
bombes124916822bombes
bombs115818822bombs
camber124418482camber
came87648752cam_e
clomb115714702clomb_
cob710258752co_b_
cobb106422002co_bb
cobber124116842cobber
cobble123615262cobble
cobbs115013992cobbs
cobby145516412cobby
coble94823172coble
cobs87043142co_bs
code77347732co_de
coke107038382co_ke
colby124415062colby
cole66956112co_le
coma87134852com_a
comade114415322comade
comake144413422comake
comal95125132comal
comas95833002comas
comate104124842comate
combat12316752combat
combers134516622combers
combine133014722combine
combos125316612combos
comer95832692comer
comes97246992comes
comet95946072comet
comfy153710212comfy
comic114721812comic
comix163513202comix
comma114514792comma
commie124215522commie
commy144712642commy
comose105016842comose
comp106731252com_p
comped135919872comped
compel124412892compel
compo115318572compo
comps115526052comps
compt116328222compt
comtes106222812comtes
cone67256962co_ne
conge85227592conge
conte76633202conte
cooee74531022cooee
coomb115615702coomb_
coombes133810662coombes
coombs124210192coombs
cope86847382co_pe
copse95623922copse
corbel103715972corbel
corbie103618202corbie
corby125018532corby
core67263112co_re
corse75036182corse
cosie74728262cosie
cote66648732co_te
coude85022632coude
coupe96023482coupe
cove95837072co_ve
coxae146115182coxae
cozie163519132cozie
crambe1239072crambe
cube85830212c_ube
cumber124016702cumber
cymae126713012cymae
cyme119420372cym_e
dome77240732dom_e
gambe106219212gambe
gombo105814042gombo
hombre13309302hombre
home98042442hom_e
homie104622532homie
jambe165314752jambe
kombu1347242kombu
lobe65535362lo_be
mome85239352mom_e
nome66038422nom_e
obe56638642_o_be
omber95316442_omber
ombre94111802_ombre
pome85636692pom_e
robe65335642ro_be
somber103714002somber
sombre10729472sombre
some66040382som_e
tomb89029652tomb_
tombed113812132tombed
tombs97818732tombs
tome67543192tom_e
womb117022232womb_
wombed14419232wombed
wombs125813342wombs
womby155910092womby
zombi1838992zombi
zombie1937322zombie

Search took 2 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.330541487.9
2DLD Change Limit538001141.42037887.3
3Display Results1141140.0333454.5
 (SQL Overall)1786911141.783100219.3
 
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.