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

92 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
jicamas184504(None) 
jicama1734871jicama_
camas96333522__camas
cicadas1235982cicadas
cicalas1139292cicalas
dicambas1553792dicambas
jacamar1844322jacamar
jacamars1944002jacamars
jacanas1638262jacanas
picaras11311272picaras
agamas97413443_agamas
amas67746293___amas
asramas938303asramas
bicarbs1336013bicarbs
bimas95521743bi__mas
cacas95627983__cacas
camass104114183__camass
cames97047313__cames
camos95927613__camos
camps116330263__camps
cams87047283__cam_s
casas75327843__casas
chacmas1637993chacmas
cicada1136413cicada_
cicadae1244853cicadae
cicala10310053cicala_
cinemas1138023cinemas
comas95833003__comas
cymas126417883__cymas
decamps1435643decamps
dicamba1453413dicamba
dicasts1078703dicasts
digammas1442983digammas
dioramas1145503dioramas
dirams94413703diram_s
dramas95814653_dramas
encamps1335423encamps
gamas85431353__gamas
gramas94317203_gramas
iambs95815053_i_ambs
iceman1037853_iceman
imams91511103_imam_s
jacales16310323jacales
jacals1539873jaca_ls
jacana1537933jacana_
jambs166014623j__ambs
jams135231073j__am_s
javas155915423j__avas
jihads1734483jiha_ds
jimjams1742073jimjam_s
jisms14458003ji_sm_s
jnanas13207303j_nanas
jorams154810533joram_s
kinaras1159093kinaras
kinemas1336883kinemas
lamas75532793__lamas
lianas63713383li_anas
limas75627633li__mas
lipomas1156443lipomas
llamas888973_llamas
mamas95930773__mamas
miasmas1167743miasmas
micas96823053mic__as
nicads938333nica_ds
nizams1735413nizam_s
oilcamps1442163oilcamps
pajamas18278153pajamas
panamas113112753panamas
picara10311903picara_
picaros11310893picaros
picas94626523pic__as
pimas94725103pi__mas
pinatas93711483pinatas
piranas9912603piranas
pirayas1277483pirayas
pitayas1286263pitayas
pyjamas21263523pyjamas
riatas63915083ri_atas
scamps125014173_scamps
scams94423973_scam_s
shamas113717933_shamas
sifakas1443333sifakas
sigmas94111353si_gmas
simas75727553si__mas
taramas9612693taramas
tiaras6314533ti_aras
ticals83214713tica_ls
ulamas8910453_ulamas
vicars11712263vica_rs
vicunas1285613vicunas
wiccas1336543wic_cas
zirams17438643ziram_s

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 Filter1786911340270.1731032896.0
2DLD Change Limit134027926.62620227.4
3Display Results92920.0303066.7
 (SQL Overall)178691926.82926166.5
 
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.