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

124 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
gambe10621921(None) 
gamb96331841gamb_
gamba106018511gamba
gambes116318311gambes
gamble115417181gamble
gambs105721121gambs
game76644321gam_e
jambe165314751jambe
abbe87627182_abbe
amber94523202_amber
amble95924632_amble
ambo88225132_ambo
amie66339842_amie
babe86835812ba_be
barbe95328282barbe
bombe115519312bombe
camber124418472camber
came87648752cam_e
combe116223542combe
crambe1239072crambe
dame77140312dam_e
daube85015302daube
fame95639392fam_e
flambe13489152flambe
gab67155992ga_b_
gabbed125216892gabbed
gabber114916602gabber
gabble113815722gabble
gabby135512942gabby
gable85325522gable
gabs76740422ga_bs
gaby107123192ga_by
gadje1457742gadje
gae46457702ga__e
gaffe124111652gaffe
gage65936102ga_ge
gale56347322ga_le
gam67060062gam__
gama77035512gam_a
gamas85431352gamas
gamay116419102gamay
gambade1336382gambade
gambas115817512gambas
gambia115912232gambia
gambier124711962gambier
gambir11509752gambir
gambit114714192gambit
gambled134112162gambled
gambler123612682gambler
gambles124016202gambles
gamboge1335582gamboge
gambol1138222gambol
gambrel1235452gambrel
gamed95126392gamed
gamer84928942gamer
games86238552games
gamete9313592gamete
gamey115320552gamey
gamic103916192gamic
gamier93617932gamier
gamin84422992gamin
gamine94620152gamine
gamma106116102gamma
gammed124216162gammed
gammer1112318332gammer
gammy135514892gammy
gamp98833212gam_p
gamps105323712gamps
gams76648882gam_s
gamut8322982gamut
gamy105427532gam_y
gane55145292ga_ne
gape75134512ga_pe
garb75332672garb_
garbed104815662garbed
garble94118452garble
garbs86321412garbs
gate55746572ga_te
gauge76117902gauge
gauze155712972gauze
gave84634052ga_ve
gaze145032412ga_ze
gibe75927772g_ibe
gimme102411342gimme
glebe85016442glebe
globe84917012globe
gombo105814042gombo
gramme114210332gramme
grebe85114942grebe
gumbo104413582gumbo
gybe105916242g_ybe
hame97043132ham_e
iamb86623722iamb_
iambi95512192iambi
iambs95815052iambs
jamb155523852jamb_
jambed184811402jambed
jambes175914052jambes
jambs166014622jambs
kame105728232kam_e
lamb86832142lamb_
lambed115614782lambed
lamber104418492lamber
lambie103213662lambie
lambs95921412lambs
lamby125114842lamby
lame66849292lam_e
mabe85733342ma_be
mamba116317512mamba
mambo115215732mambo
mamie95826002mamie
maybe12311122maybe
nabe66029492na_be
name65637412nam_e
ramble104519972ramble
ramee74633852ramee
ramie75027822ramie
sabe66140572sa_be
samba95618772samba
sambo95118012sambo
same65245642sam_e
tame66343662tam_e
wamble134415752wamble
wame95035482wam_e

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.1101624463.6
2DLD Change Limit538001241.54634799.5
3Display Results1241240.0304133.3
 (SQL Overall)1786911241.686105985.2
 
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.