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

99 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
sarcinae104719(None) 
sarcina9310731sarcina_
sarcinas1039271sarcinas
carinae94318582car_inae
sardine83317392sardin_e
acinar8310483_a_cinar
arcana8912583_arcana_
arcane81216743_arcan_e
archine125817053_archin_e
arcing95819643_arcin_g
arcsine94512393_arcsin_e
arginase946433_arginase
arsine64021043_arsin_e
calcine11315273calcin_e
carbine112918643carbin_e
cardiae10713703cardi_ae
cardinal1139563cardinal
carina84325323car_ina_
carinal94318233car_inal
carinas93622403car_inas
carinate103320243car_inate
carline93923613carlin_e
carmine112918483carmin_e
circinate1347813circinate
faciae112913413fa_ci_ae
farcical1546953farcical
farcie114816473farci__e
farcing133514003farcin_g
farina94618233far_ina_
farinas103215233far_inas
fasciae1247523fasci_ae
fascinate1447763fascinate
fascine12510583fascin_e
harmine122816193harmin_e
hircine1239143hircin_e
jarina134014063jar_ina_
jarinas143712183jar_inas
katcina1345153katcina_
katcinas1434513katcinas
lacunae9116803la_cunae
laminae93512973la_minae
lancinate1147803lancinate
larine63927043lar_in_e
marginal1137603marginal
marginate12179603marginate
marina84623413mar_ina_
marinade11259383mar_inade
marinas93519383mar_inas
marinate103017783mar_inate
marine84230403mar_in_e
marline93320953marlin_e
narceine1046753narcein_e
nardine82712573nardin_e
narine63422553nar_in_e
pardine103616723pardin_e
patinae95414403pa_tinae
piscinae1285213piscinae
porcine11312843porcin_e
sabine84020393sa_bin_e
sacring103115983sacrin_g
sacrings11278923sacrings
salicine10311703salicin_e
salina64221123sa_lina_
salinas73116093sa_linas
saline65132703sa_lin_e
saltine75018563saltin_e
saphenae1344853saphenae
sarcenet10413313sarcenet
sarcoma1147403sarcoma_
sarcomas1247223sarcomas
sardana838643sardana_
sardanas937813sardanas
sardined10268663sardined
sardines92815563sardines
sarin55239253sar_in__
sarins63932623sar_in_s
saucing10311003saucin_g
savine94220283sa_vin_e
serine65432673ser_in_e
shrine94920053shr_in_e
sordine82515233sordin_e
soricine10710883soricin_e
spartina1037983spartina_
spartinas1135793spartinas
springe103913983spr_inge
striae65422273str_i_ae
succinate1346683succinate
surcingle1243953surcingle
syringe11349473syr_inge
tacrine9311293tacrin_e
tsarina736653tsar_ina_
tsarinas835273tsar_inas
vaccina1435303vaccina_
vaccinal1544903vaccinal
vaccinas1544973vaccinas
vaccinate1646833vaccinate
vaccine1437323vaccin_e
vaccinee1544853vaccinee
vaginae11377683va_ginae

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit146162997.95318378.2
3Display Results99990.0303300.0
 (SQL Overall)178691998.38921300.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.