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 “jambe” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

75 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
jambe16531475(None) 
gambe106219211gambe
jamb155523851jamb_
jambed184811401jambed
jambes175914051jambes
jambs166014621jambs
abbe87627192_abbe
amber94523212_amber
amble95924642_amble
ambo88225142_ambo
amie66339852_amie
babe86835822ba_be
barbe95328282barbe
bombe115519312bombe
camber124418482camber
came87648752cam_e
combe116223542combe
crambe1239072crambe
dame77140312dam_e
daube85015302daube
fame95639392fam_e
flambe13489152flambe
gamb96331842gamb_
gamba106018512gamba
gambes116318312gambes
gamble115417182gamble
gambs105721122gambs
game76644322gam_e
hame97043132ham_e
iamb86623732iamb_
iambi95512222iambi
iambs95815062iambs
jab128444112ja_b_
jabbed184213482jabbed
jabber173713642jabber
jabs135830092ja_bs
jade125325442ja_de
jake155925772ja_ke
jam126942522jam__
jambeau1843772jambeau
jammed183811502jammed
jammer174014132jammer
jammy194810192jammy
jams135231072jam_s
jane115031482ja_ne
jape134923422ja_pe
jibe136323392j_ibe
jube136322782j_ube
jumble174012652jumble
jumbo164311072jumbo
kame105728232kam_e
lamb86832142lamb_
lambed115614782lambed
lamber104418492lamber
lambie103213672lambie
lambs95921412lambs
lamby125114842lamby
lame66849292lam_e
mabe85733362ma_be
mamba116317522mamba
mambo115215742mambo
mamie95826002mamie
maybe12311132maybe
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.296603685.8
2DLD Change Limit53800751.50035866.7
3Display Results75750.0164687.5
 (SQL Overall)178691751.81298615.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.