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

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

80 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
jicama1734881jicama
bicarb1238542bicarb
dicamba1453412dicamba
iamb86623732_i_amb
jamb155523852j__amb
jicamas1845052jicamas
became123213163became
bicarbs1336013bicarbs
bigamy1436343bigamy
cab78355403__ca_b
cam78058983__cam_
came87648753__came
camo85731753__camo
camp106336453__camp
cams87047283__cams
carb85143163__carb
cicada1136413cicada
cicala10310063cicala
cicale10314503cicale
comb106632113__comb
decamp1338453decamp
dicambas1553793dicambas
dicast9315573dicast
digamy1335893digamy
diram84419473diram_
dirams94413703dirams
encamp1235943encamp
gamb96331843__gamb
hijab1736803hija_b
iambi95512223_i_ambi
iambs95815063_i_ambs
imam81718333_imam_
imams91511113_imams
jab128444113j__a_b
jacal14313703jaca_l
jacals1539873jacals
jacamar1844323jacamar
jacana1537933jacana
jam126942523j__am_
jambe165314753j__ambe
jambs166014623j__ambs
jams135231073j__ams
jiao115017843ji_a_o
jib125835973ji___b
jibb155816743ji__bb
jihad1635913jiha_d
jihads1734483jihads
jimjams1742073jimjams
jimmy19538503ji_mmy
jimp155618463ji__mp
jism135514773ji_sm_
jisms14458003ji_sms
joram145816983joram_
jorams154810533jorams
lamb86832143__lamb
limb85429383li__mb
mica86428253mica__
micas96823053mica_s
nicad8312613nica_d
nicads938333nicads
nizam16310253nizam_
nizams1735413nizams
oilcamp1343053oilcamp
pica85831493pica__
pical95524373pica_l
picara10311903picara
picaro10311323picaro
picas94626523pica_s
recomb1238873recomb
scab85926713_sca_b
scam85932353_scam_
scamp115717313_scamp
scams94423973_scams
tical76021493tica_l
ticals83214713ticals
vicar10513863vica_r
vicars11712263vicars
vocab12409973voca_b
ziram163912893ziram_
zirams17438643zirams

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit112716805.59320153.0
3Display Results80800.0332424.2
 (SQL Overall)178691806.01629702.6
 
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.